G
Guest
ow do I add 42 dyas to a given date, not including weekends or specific
holidays?
holidays?
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
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
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
G
Guest
Thank you very much!!!!
Peo Sjoblom said: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
G
Guest
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?
the holiday field cells. Is there a way to lock in the Holiday field cells as
I originally used?
J
JulieD
Hi
if you have your holidays in A1:A10 use $A$1:$A$10 in the formula
if you have your holidays in A1:A10 use $A$1:$A$10 in the formula
B
Bob Phillips
or use a name (Insert>Name>Define Name...)