View Single Post
 
Old 11-14-2013, 02:30 AM
cristinaadword cristinaadword is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Nov 2013
Posts: 2
cristinaadword is on a distinguished road
Default

Hi,
I guess you mean the number of weekdays (or working days) excluding Saturdays and Sundays. So start a spreadsheet and put the start date (28/10/2013) in A2 and the end date (11/11/2013) in B2.

Then paste the formula below into C2:

=B2-A2-2*INT ((B2-A2+WEEKDAY (A2, 3))/7)-MAX (0, WEEKDAY (B2, 3)-4


Thanks, I hope it works for you.....
Reply With Quote