Forum Discussion
Excel Help for time limit.
Hello experts, please help me,
Is there any way so that I can limit a cell for a specific period of time in which cell can be edited. After the time limit is over, the cell should not be edited.
Please help me.
- Select the cells you want to protect and the click on Data -> Data Validation - Then choose the option as shown in the image below - Or this (where A1 is a reference to a cell containing a date) - Hope that helps 
4 Replies
- You could add Data Validation with a formula - Where the figure of 43585 is the number equivalent of any date - (type a date in a cell and change the format to General) - Ahmad200Copper ContributorI have not got it. Please help me. I am not able to understand what you said in your response.- Select the cells you want to protect and the click on Data -> Data Validation - Then choose the option as shown in the image below - Or this (where A1 is a reference to a cell containing a date) - Hope that helps