| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Diff - excluding working days
Hi all, Does anyone know how i can return the difference between two dates
that across weeks, months and years and only count working days? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Diff - excluding working days
Use NETWORKDAYS, that is exactly what it is for.
-- HTH Bob "Scott_goddard" wrote in message ... Hi all, Does anyone know how i can return the difference between two dates that across weeks, months and years and only count working days? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Diff - excluding working days
You will want to use the NETWORKDAYS function... if you are using XL2007 or
later, this function is built into Excel... if you are using XL2003 or earlier, you need to activate the Analysis ToolPak add-in (Click Tools/Add-Ins on the Excel menu bar). -- Rick (MVP - Excel) "Scott_goddard" wrote in message ... Hi all, Does anyone know how i can return the difference between two dates that across weeks, months and years and only count working days? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| Date + X days excluding holidays | Excel Discussion (Misc queries) | |||
| Working Days excluding Sundays | Excel Discussion (Misc queries) | |||
| Due date excluding weekend days | Excel Worksheet Functions | |||
| date (minus) date = working days diff | Excel Discussion (Misc queries) | |||
Hybrid Mode
