SOLVED

Excel Help for time limit.

Copper 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

@Ahmad200 

 

You could add Data Validation with a formula

 

image.png

 

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.
best response confirmed by Ahmad200 (Copper Contributor)
Solution

@Ahmad200 

 

Select the cells you want to protect and the click on Data ->  Data Validation

 

image.png

 

Then choose the option as shown in the image below

 

image.png

 

Or this (where A1 is a reference to a cell containing a date)

 

image.png

 

Hope that helps

 

Just let me try. I will respond you shortly. Thanks
1 best response

Accepted Solutions
best response confirmed by Ahmad200 (Copper Contributor)
Solution

@Ahmad200 

 

Select the cells you want to protect and the click on Data ->  Data Validation

 

image.png

 

Then choose the option as shown in the image below

 

image.png

 

Or this (where A1 is a reference to a cell containing a date)

 

image.png

 

Hope that helps

 

View solution in original post