Thread: [Solved] Calculating turnaround times in excel
View Single Post
 
Old 11-14-2013, 04:33 AM
Swooshy Swooshy is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Nov 2013
Posts: 7
Swooshy is on a distinguished road
Default
Quote:
Originally Posted by cristinaadword View Post
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
Reply With Quote