| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count days between two dates excluding weekends
On Fri, 18 Feb 2011 13:44:09 -0800 (PST), JGGL wrote:
What formula should I use to count the # of days between 2 dates excluding weekends? =networkdays(start_date,end_date) If you are using a version of Excel prior to 2007, and you get a #NAME error, goto HELP for the NETWORKDAYS function to see how to install the Analysis Tool Pak. Note that this function counts BOTH the start and end dates, so depending on your requirements, you may need to subtract 1 from the result. |
| 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) | |||
| CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS | Excel Worksheet Functions | |||
| Counting dates but excluding weekends | Excel Worksheet Functions | |||
| excel total days formula including weekends, excluding holidays | Excel Discussion (Misc queries) | |||
| How do you count work days excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
![Ron Rosenfeld[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
