Backward Planning in Excel

[DietCokeMan]

Could some explain by the numbers how to Backward Plan in Excel?

My event start 4 March 08. I would like to know the dates:
D-30
D-60
D-90
D-120

Would like to reflect Weekdays (Mon-Fri) and exclude Holidays.

I know you use the function =Workday (????) but dont know the syntax.

Thanks

Ken

 

[GlennUK]

I think ( can't check, Analysis Toolpak add-in is not installed here ) it's like:
=WORKDAY(A2,-90,Holidays)

where the start date is in cell A2, and Holidays is a named range containing a list of the holidays you want excluded.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[DietCokeMan]

Thanks Glenn,

Sorry it took so long to get back. WORKED GREAT. Definitely had to have the packs installed.

Ken

 

[GlennUK]

My pleasure :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.