Dates calculation should consider holidays and weekends to suggest

[Abhishek]

Hi,

I need a calculation wherein the user just enters a begin date and then my
formula adds a few months and days to that date and suggests a date, but it
does not consider holidays and weekends in the calc.

For example If I suggest April15, the formula should be able to find out
that April 15 is sunday and also April 16 is Holiday, so it should suggest
April 17.

Does anyone have any idea for this.

Will be glad to receive your response.

 

[Gary Keramidas]

try the holidays parameter of networkdays

http://support.microsoft.com/kb/259200

 

[Abhishek]

I am using Excel 2003. Does networkdays work in 2003 also?

 

[Gary Keramidas]

yes, just install the analysis toolpak add-in.

 

[Abhishek]

Yes, that worked, thanks a lot Gary...

yes, just install the analysis toolpak add-in.