Validating Dates Entered
 

How can I set this up?

If Column A is blank then no date can be added to Column B;

If there is a date in Column A then Column B must be equal to or
greater (=) than Column A

Seems like it should be easy enough but I can't get it to work.

Thanks! :confused:


--
patam
------------------------------------------------------------------------
patam's Profile: http://www.excelforum.com/member.php...fo&userid=3192
View this thread: http://www.excelforum.com/showthread...hreadid=401502

Select Cell B1

On Menu Bar, select Data Validation

Settings:
Allow Custom
Ignore Blank not checked
Formula should be =AND(A1<"",B1A1)


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=401502

One way:

Data/Validation/ Allow Custom:

=AND(A1<"",B1=A1)

uncheck the Ignore blank checkbox.

In article ,
patam wrote:

How can I set this up?

If Column A is blank then no date can be added to Column B;

If there is a date in Column A then Column B must be equal to or
greater (=) than Column A

Seems like it should be easy enough but I can't get it to work.

Thanks! :confused: