subtracting networkdays

[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?

 

[Peo Sjoblom]

=WORKDAY(A2,2,Holidays)

=WORKDAY(A2,-2,Holidays)

look it up in help

--


Regards,


Peo Sjoblom

 

[Steve]

Thanks for the info, but I keep getting an error message #name? Any thoughts?

 

[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

 

[Steve]

Any other suggestions? I do have the toolpac loaded and installed....I redid
it, but nothing..

 

[Steve]

IT HAS BEEN FIXED! THANKS EVERYONE!

Any other suggestions? I do have the toolpac loaded and installed....I redid
it, but nothing..