| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Eliminating weekends when subtracting dates
Hi,
I have a date in cell E18, and a number in cell E16. I need to subtract cell E16 from E18, and eliminate the weekends. I want the result to be a date. I am trying the NETWORKDAYS function, but cant get it to work. It only gives me the number of days between 2 dates. Does it only give numerical results? Thanks, Michael |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Eliminating weekends when subtracting dates
You want the WORKDAY function which, like NETWORKDAYS, requires the Analysis
ToolPak (unless you are using XL2007 in which case it is a built-in function). Rick "mdub" wrote in message ... Hi, I have a date in cell E18, and a number in cell E16. I need to subtract cell E16 from E18, and eliminate the weekends. I want the result to be a date. I am trying the NETWORKDAYS function, but cant get it to work. It only gives me the number of days between 2 dates. Does it only give numerical results? Thanks, Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtracting date and time formats excluding weekends | Excel Worksheet Functions | |||
| help with subtracting time excluding weekends and non-working hour | Excel Worksheet Functions | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| get hours between 2 dates subtracting the weekends | Excel Discussion (Misc queries) | |||
| Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
Linear Mode
