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

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,
toolsadd-ins check ATP


--
Regards,

Peo Sjoblom


"JP" wrote in message
...
ow do I add 42 dyas to a given date, not including weekends or specific
holidays?

Thank you very much!!!!

"Peo Sjoblom" wrote:

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,
toolsadd-ins check ATP


--
Regards,

Peo Sjoblom


"JP" wrote in message
...
ow do I add 42 dyas to a given date, not including weekends or specific
holidays?

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?

"Peo Sjoblom" wrote:

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,
toolsadd-ins check ATP


--
Regards,

Peo Sjoblom


"JP" wrote in message
...
ow do I add 42 dyas to a given date, not including weekends or specific
holidays?

Hi

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"JP" wrote in message
...
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?

"Peo Sjoblom" wrote:

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,
toolsadd-ins check ATP


--
Regards,

Peo Sjoblom


"JP" wrote in message
...
ow do I add 42 dyas to a given date, not including weekends or specific
holidays?

or use a name (InsertNameDefine Name...)

--
HTH

Bob Phillips

"JulieD" wrote in message
...
Hi

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"JP" wrote in message
...
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?

"Peo Sjoblom" wrote:

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,
toolsadd-ins check ATP


--
Regards,

Peo Sjoblom


"JP" wrote in message
...
ow do I add 42 dyas to a given date, not including weekends or
specific
holidays?