Quote:
Originally Posted by cristinaadword
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.....
|
i want the number of working days but that can include some Saturday's and Sundays, I only want to exclude the set list of dates that I will have in another tab.
Can you walk me through the formula that you posted so that i can understand what is going on there if you think it is something that will answer my question
11-14-2013, 04:33 AM
Similar Threads
calculating duration
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode