Previous Topic Next Topic

Date Entry

Solved/Closed
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Dec 27, 2014 at 11:35 PM
ArashMan Posts 38 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.
Related:

1 response

Answer 1 / 1
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 38 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

Similar discussions

Need for Speed most wanted install problem
jay -
sarfaraz -

7 responses
Need for Speed crashes on desktop
recommendspc -
GINO -

20 responses
Messenger missing emojis
poldoms -
ellielo -

2 responses
Missing emojis on messenger android
justZer0 -
HelpiOS -

1 response