Lock it in....

I am using the WORKDAY function and it is working correctly, however when I
copy the formula to another cell, it changes the Holiday cells. Is there any
way to prevent this from happening by locking the holiday cells?

Hi
You need to use absolute references for your holiday cells. In your WORKDAY
formula, instead of using A2:A8 for your holiday reference (for example) use
$A$2:$A$8
Hope this helps.

--
Andy.


"JP" <JP@discussions.microsoft.com> wrote in message
news:5BC2C8CC-F4BF-49F1-9248-F9CF46CA630C@microsoft.com...
>I am using the WORKDAY function and it is working correctly, however when I
> copy the formula to another cell, it changes the Holiday cells. Is there
> any
> way to prevent this from happening by locking the holiday cells?

JP, use and Absolute reference for the holidays, like this

=WORKDAY(A1,A2,$A$3:$A$10)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JP" <JP@discussions.microsoft.com> wrote in message
news:5BC2C8CC-F4BF-49F1-9248-F9CF46CA630C@microsoft.com...
> I am using the WORKDAY function and it is working correctly, however when
I
> copy the formula to another cell, it changes the Holiday cells. Is there
any
> way to prevent this from happening by locking the holiday cells?