S
Steve
I would like to subtract and add (in two different columns), 2 WORK DAYS from
a given date. Does anyone know how to do this?
a given date. Does anyone know how to do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
=WORKDAY(A2,2,Holidays)
=WORKDAY(A2,-2,Holidays)
look it up in help
--
Regards,
Peo Sjoblom
=WORKDAY(A2,-2,Holidays)
look it up in help
--
Regards,
Peo Sjoblom
S
Steve
Thanks for the info, but I keep getting an error message #name? Any thoughts?
R
Ron Rosenfeld
Thanks for the info, but I keep getting an error message #name? Any thoughts?
You don't have the ATP installed.
If you look at HELP for the WORKDAY function, you will see that error listed
and also how to fix it.
--ron
S
Steve
Any other suggestions? I do have the toolpac loaded and installed....I redid
it, but nothing..
it, but nothing..
S
Steve
IT HAS BEEN FIXED! THANKS EVERYONE!
Steve said:Any other suggestions? I do have the toolpac loaded and installed....I redid
it, but nothing..