|
|
#7
11-14-2013, 02:30 AM
|
|||
|
|||
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..... 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need a formula to calculate turnaround time | Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
| Calculating Profits? | MarkL | Project | 1 | 06-12-2012 07:19 AM |
 calculating duration
|
ketanco | Project | 5 | 12-15-2011 07:15 PM |
|
Calculating dates
|
Daria11 | Word VBA | 1 | 06-08-2011 06:54 PM |
| calculating points and division in excel | edward masoya | Excel | 1 | 05-09-2011 06:31 AM |
Windows 7 32bit 
Office 2007
Threaded Mode