Date Entry [Solved/Closed]

Report
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
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

Posts
5
Registration date
Monday December 29, 2014
Status
Member
Last seen
December 30, 2014
1
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2951 users have said thank you to us this month

Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
thanks shanthich
it helps lot.