| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating number of workdays
Hello,
I need to calculate the number of working days (monday to friday) between two dates. For example: the number of working days between 2006-08-25 and 2006-08-28 should be 1, since the 26th and 27th are saturday and sunday. The datediff function however returns 3. Is there another function I can use or do I have to write a custom function? Regards PO |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating number of workdays
Use the function NETWORKDAYS
-- Brevity is the soul of wit. "PO" wrote: Hello, I need to calculate the number of working days (monday to friday) between two dates. For example: the number of working days between 2006-08-25 and 2006-08-28 should be 1, since the 26th and 27th are saturday and sunday. The datediff function however returns 3. Is there another function I can use or do I have to write a custom function? Regards PO |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Number of days from one date to another | Excel Discussion (Misc queries) | |||
| Calculating number of periods when payment amount changes | Excel Worksheet Functions | |||
| How do you calculate number of workdays from dates entered? | Excel Worksheet Functions | |||
| How do you calculate number of workdays from dates entered? | Excel Worksheet Functions | |||
| Calculating interest on number of days in the period | Excel Worksheet Functions | |||
Linear Mode
