Forum Discussion
Making cells/columns inaccessible until a certain amount of time has passed since a specific date?
Thank you, this worked partially. The validation needs to happen across multiple sheets (pay periods), and automatically prevent the user from entering data in those cells till the date identified by the formula has been reached in real time. So if the equation is =TODAY()>EDATE(C5, 6) with C5=1/1/2023 and the answer to EDATE(C5,6) being 7/1/2023, I want excel to recognize that the date 7/1/2023 has been reached in real time and disable the function for the remaining cells. Is this possible?
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.
