MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need formula to determine # of days??

Posted by Rick M on February 09, 2001 10:24 AM

I need a formula to determine the number of days it took to service an account.
Post date = 12/1/2000
Service date = 12/4/2000
Days to service should = 1 because 12/2 is Saturday and 12/3 is a Sunday....
I don't care about holidays, but need to exclude weekends.

Posted by SJC on February 09, 2001 11:15 AM

You can use NETWORKDAYS for this. The syntax is: =NETWORKDAYS(start_date, end_date)