H

[JP]

ow do I add 42 dyas to a given date, not including weekends or specific
holidays?

 

[Peo Sjoblom]

Look in help for WORKDAY

WORKDAY(start_date,days,holidays)

it's part of the ATP add-in so if you didn't install it the first time you
need to install it,
tools>add-ins check ATP

 

[JP]

Thank you very much!!!!

Look in help for WORKDAY

WORKDAY(start_date,days,holidays)

it's part of the ATP add-in so if you didn't install it the first time you
need to install it,
tools>add-ins check ATP

 

[JP]

It is calculating correctly, however when I copy the formula, it is changing
the holiday field cells. Is there a way to lock in the Holiday field cells as
I originally used?

 

[JulieD]

Hi

if you have your holidays in A1:A10 use $A$1:$A$10 in the formula

 

[Bob Phillips]

or use a name (Insert>Name>Define Name...)