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...
- Thank you, this is very close! The formula needed to be changed to say > rather than <, which created the conditions I was looking for. Only issue is that the A column value has to be selected in the equation, so if I apply this =$A11>EDATE($O$24,6) to the Data Validation, then the command is not based on whether the user is accessing the document 6 months from the date in O24 at the time of access.
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.