| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date (minus) date = working days diff
Hello All, Quick and easy one (I hope), i have two dates how can i work out the working days between them ? Kind Regards JJJ -- jjj ------------------------------------------------------------------------ jjj's Profile: http://www.excelforum.com/member.php...fo&userid=7424 View this thread: http://www.excelforum.com/showthread...hreadid=490742 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date (minus) date = working days diff
Use the NETWORKDAYS() function
If you get a #NAME error: ToolsAdd-ins, check Analysis Toolpak -- Kind regards, Niek Otten "jjj" wrote in message ... Hello All, Quick and easy one (I hope), i have two dates how can i work out the working days between them ? Kind Regards JJJ -- jjj ------------------------------------------------------------------------ jjj's Profile: http://www.excelforum.com/member.php...fo&userid=7424 View this thread: http://www.excelforum.com/showthread...hreadid=490742 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date (minus) date = working days diff
Check out the NETWORKDAYS() function in XL Help. Note that it's an
Analysis Toolpak Add-in function (Tools/Add-ins...) In article , jjj wrote: Hello All, Quick and easy one (I hope), i have two dates how can i work out the working days between them ? Kind Regards JJJ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date (minus) date = working days diff
Hi
Try =NETWORKDAYS(firstdate,seconddate,holidays) Networkdays is part on the Analysis Toolpak so go to ToolsAddins and ensure Analysis Toolpak is selected. Substitute the cell reference holding your earliest date for firstdate, and the cell ref for your latest date fro seconddate. Holidays is either a list of cells containing public holidays, or a named range containing the holiday dates. Regards Roger Govier jjj wrote: Hello All, Quick and easy one (I hope), i have two dates how can i work out the working days between them ? Kind Regards JJJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to project the due date according to a number of working hours | Excel Discussion (Misc queries) | |||
| Calculating Working Days - Department of Pathology | Excel Discussion (Misc queries) | |||
| calculate the number of days from date received | Excel Worksheet Functions | |||
| subtracting 30 days from any date. | Excel Discussion (Misc queries) | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
Linear Mode
