Forum Discussion
Excell Format Protection and Formula Question.
I made changes to your formula and used this instead. For example for cell A1:
=IF(DAY(C1)-WEEKDAY(C1)<7,"1st",IF(DAY(C1)-WEEKDAY(C1)<14,"2nd",IF(DAY(C1)-WEEKDAY(C1)<21,"3rd","4th")))&" SUNDAY WEEK 1"
and after that I just copied and paste it to the rest of the cell A16, A31, and A46 and only change the last part of your text string to WEEK2, WEEK3, and WEEK 4.
As for protecting the worksheet, all you need to do is highlight all the cells that could only be modified and any additional cells you need to highlight just hold crtl key. Once you're done right-click and select format cells and uncheck locked. After that, you can protect your worksheet. By default, all cells are locked unless you unlock them.
I made changes to your formula and used this instead. For example for cell A1:
=IF(DAY(C1)-WEEKDAY(C1)<7,"1st",IF(DAY(C1)-WEEKDAY(C1)<14,"2nd",IF(DAY(C1)-WEEKDAY(C1)<21,"3rd","4th")))&" SUNDAY WEEK 1"
and after that I just copied and paste it to the rest of the cell A16, A31, and A46 and only change the last part of your text string to WEEK2, WEEK3, and WEEK 4.
As for protecting the worksheet, all you need to do is highlight all the cells that could only be modified and any additional cells you need to highlight just hold crtl key. Once you're done right-click and select format cells and uncheck locked. After that, you can protect your worksheet. By default, all cells are locked unless you unlock them.
