Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
how can I do "Date math" using only business days?
|
#2
![]() |
|||
|
|||
![]()
See the NETWORKDAYS and WORKDAY functions. These are part of the
Analysis Tool Pack add-in, so you must have this loaded to use the functions. Go to the Tools menu, choose Add-Ins, and put a check next to "Analysis Tool Pak". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "S trainer" <S wrote in message ... how can I do "Date math" using only business days? |
#3
![]() |
|||
|
|||
![]()
Install Analysis Tool Pack add-in if it isn't already on your machine. Then
use the NETWORKDAYS() function. Carlos "S trainer" <S wrote in message ... how can I do "Date math" using only business days? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions |