Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate the number of workdays between 2 dates
Dave R. Thanks for the quick help, that did the trick! Do you know if there is a way to have it not count holidays also? If so can you enter in a custom holiday calendar? -- Tegid77 ------------------------------------------------------------------------ Tegid77's Profile: http://www.excelforum.com/member.php...o&userid=16087 View this thread: http://www.excelforum.com/showthread...hreadid=275376 |
#2
|
|||
|
|||
Tegid77 Wrote: Dave R. Thanks for the quick help, that did the trick! Do you know if there is a way to have it not count holidays also? If so can you enter in a custom holiday calendar? =NETWORKDAYS(Date1,Date2,Holidays) where Holidays refers to a range housing known holiday dates. -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=275376 |
#3
|
|||
|
|||
Did you try Help for this function. It answers your question.
On Thu, 4 Nov 2004 13:54:46 -0600, Tegid77 wrote: Dave R. Thanks for the quick help, that did the trick! Do you know if there is a way to have it not count holidays also? If so can you enter in a custom holiday calendar? |
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) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Calculate the number of workdays between 2 dates | Excel Worksheet Functions | |||
calculate with dates before 1-1-1900 | Excel Worksheet Functions |