| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Calculate the number of workdays between 2 dates
I am trying to figure how many workdays between 2 dates and wondering what the best way of doing this would be any advice would be greatly appreciated -- Tegid77 ------------------------------------------------------------------------ Tegid77's Profile: http://www.excelforum.com/member.php...o&userid=16087 View this thread: http://www.excelforum.com/showthread...hreadid=275376 |
|
#2
|
|||
|
|||
|
Try =NETWORKDAYS(A1,A2) with the earlier date in A1 and later date in A2.
"Tegid77" wrote in message ... I am trying to figure how many workdays between 2 dates and wondering what the best way of doing this would be any advice would be greatly appreciated -- Tegid77 ------------------------------------------------------------------------ Tegid77's Profile: http://www.excelforum.com/member.php...o&userid=16087 View this thread: http://www.excelforum.com/showthread...hreadid=275376 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| calculate with dates before 1-1-1900 | Excel Worksheet Functions | |||
Hybrid Mode
