Date Entry

Solved/Closed
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Dec 27, 2014 at 11:35 PM
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Dec 30, 2014 at 03:46 AM
Hello,

i have an Excel sheet which my colleague should enter the date after he finished his job,
for example:\today date is 2014/28/12

he should finished his job in 2014/25/12 but he didnt, but today( 2014/28/12) he will enter the date of 2014/25/12
i want a way that my colleague cant enter the day of previous date.
is there any way, thanks for your great answers.

1 reply

shanthich Posts 5 Registration date Monday December 29, 2014 Status Member Last seen December 30, 2014 1
Dec 29, 2014 at 01:40 PM
Put in a data validation.

First have a fixed cell in your sheet, say D3 where D3 = today()

For this, go to Data> Validate> Data Validation >
Allow: Date
Date: greater than or equal to
Start Date: D3

OK
1
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 30, 2014 at 03:46 AM
thanks shanthich
it helps lot.
0