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

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