| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I find how many business days are between two dates
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
