Hello: I am a sharepoint novice. Using Sharepoint 3.0 In Excel I can calculate the number of workdays left between 2 dates. =NETWORKDAYS(Todays date,Project end Date)-2 the -2 represents non-working holidays. Is there a way to create a webpart on a sharepoint page to do what I do in Excel? If possible please provide detailed instructions how to create. Thank you Eric

HI, Excel Networkdays function implementation in sharepoint realted question is already postedin MS Technet forum. http://social.technet.microsoft.com/forums/en-US/sharepointgeneral/thread/d71cb2b8-72f7-4b9f-a5c9-7c08a9ccf6c9/ Refer this url, this will help you. Regards

Thanks Nehruraj. I think I can use this formula that I found from your previous link post. SharePoint NETWORKDAYS Formula (for Start and End dates that are Week days) =IF(AND((WEEKDAY([End Date],2))<(WEEKDAY([Start Date],2)),((WEEKDAY([Start Date],2))-(WEEKDAY([End Date],2)))>1),(((DATEDIF([Start Date],[End Date],"D")+1))-(FLOOR((DATEDIF([Start Date],[End Date],"D")+1)/7,1)*2)-2),(((DATEDIF([Start Date],[End Date],"D")+1))-(FLOOR((DATEDIF([Start Date],[End Date],"D")+1)/7,1)*2))) How do I exclude a certain number of company holidays in the formula? Can I paste this code into a webpart? In the link from above they talk about adding a column. I am a novice sharepoint user. Thank you Eric

Hi Eric, The formula is used to a calculated column in a list, you can display a list in a web part within a page. For excluding 2 days for holidays, you can “-2” in the last 2 parameters like this, =IF(AND((WEEKDAY([End Date],2))<(WEEKDAY([Start Date],2)),((WEEKDAY([Start Date],2))-(WEEKDAY([End Date],2)))>1),((((DateDIF([Start Date],[End Date],"D")+1))-(FLOOR((DateDIF([Start Date],[End Date],"D")+1)/7,1)*2)-2)-2),((((DateDIF([Start Date],[End Date],"D")+1))-(FLOOR((DateDIF([Start Date],[End Date],"D")+1)/7,1)*2))-2)) Thanks Regards, Daniel