| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for dates minus the weekends
I need help finding a formula that will figure out the days minus weekend days.
Ex: Due date Ship date #of days early # of days late 4/16/07 4/26/07 7 I would like for the # of days early or # of days late to give me a # BUT not counting weekend days. Is there anyway to do this? -- TJH |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for dates minus the weekends
look at networkdays() in help. note you must have the data analysis addin
activated for it to work. "TJH" wrote: I need help finding a formula that will figure out the days minus weekend days. Ex: Due date Ship date #of days early # of days late 4/16/07 4/26/07 7 I would like for the # of days early or # of days late to give me a # BUT not counting weekend days. Is there anyway to do this? -- TJH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting dates on the Y axis without weekends | Charts and Charting in Excel | |||
| get hours between 2 dates subtracting the weekends | Excel Discussion (Misc queries) | |||
| Calculate Number of Days Between Dates Minus Weekends | Excel Discussion (Misc queries) | |||
| Chronolize dates with varying days minus weekends | Excel Worksheet Functions | |||
| How to Calculate Dates without counting the weekends | Excel Worksheet Functions | |||
Linear Mode
