Excel Help for time limit.

Occasional Contributor

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.

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)

I 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


Just let me try. I will respond you shortly. Thanks
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies