Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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" wrote in message ... 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? |
#3
|
|||
|
|||
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock formula?? | Excel Worksheet Functions | |||
how do I lock formulas, but I can still delete data? | Excel Worksheet Functions | |||
The $ thing to lock cells at rows or columns | Excel Discussion (Misc queries) | |||
Lock cell shading and size only | Excel Worksheet Functions | |||
comment indicators should feature lock or pw protect limiting acc. | Excel Worksheet Functions |