For the question:

Uncheck Ignore blank

=AND(COUNT(A4),COUNT(A5),A5=A4)

For the alternate:

=AND(COUNT(A4),A5=TODAY())

--
Biff
Microsoft Excel MVP


"jpreman" wrote in message
...
Thanks for reading this post.

In column A I would like to enter dates. For instance the date entered in
A5
should be verified for the following.

Question :-

1 If A4 is blank, no entry should be permitted in A5
2 If A4 is not blank, then A5 could be equal to or greater than A4


Alternate :-

1 If A4 is blank, no entry should be permitted in A5
2 If A4 is not blank, then A5 should be equal to TODAY( )

What should be the CUSTOM/FORMULA for both the above validations?

Thanks in advance

Regards

Preman