| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you calculate number of workdays from dates entered?
I've got this form at work where the user wants to be able to enter dates
into certain cells and write a formula that will calculate how many workdays are between each date enter. We're talking the standard work week of 5 days. Also, how about holidays? |
|
#2
|
|||
|
|||
|
Take a look at the NETWORKDAYS() function. Look in HELP for details.
-- Kind Regards, Niek Otten Microsoft MVP - Excel "tfleck" wrote in message ... I've got this form at work where the user wants to be able to enter dates into certain cells and write a formula that will calculate how many workdays are between each date enter. We're talking the standard work week of 5 days. Also, how about holidays? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you calculate number of workdays from dates entered? | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions | |||
| Calculate the number of workdays between 2 dates | Excel Worksheet Functions | |||
| Calculate the number of workdays between 2 dates | Excel Worksheet Functions | |||
Linear Mode
