Forum Discussion
Making cells/columns inaccessible until a certain amount of time has passed since a specific date?
I want to edit a timesheet so that a employee cannot edit specific cells/columns till 6 months past a certain date has passed. I have attempted with conditional formatting and data validation using a...
I guess time of access is TODAY(). If user open the file (s)he accessed it. If you need both conditions it could be like
=($A11<EDATE($O$24,6) )*( TODAY()<EDATE($O$24,6) ) or like
Thank you. Unfortunately I am still not achieving what I am looking for. As you can see, all cells except for R9 and R13 allow for values to be entered into the cells.
Please check attached
