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...
Sorry, I didn't catch. Date 7/1/2023 is fixed through cell C5 and number of months. We compare it with current date, thus the rule works dynamically. If the rule meets condition you may enter any value into the cell with that rule. If not we have an alert and no value could be added here. We may apply the rule to as many cell as needed and use in formula cells from another sheets.
Perhaps you illustrate on small sample file or at least screenshot how exactly your data is structured and which cells are to be verified.
- 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
