Thanks for responding to my post Madhu.

The formula did not satisfy condition 1. Perhaps you can take have a look
and correct it.

Regards

Preman

"muddan madhu" wrote:

data validation for the cell A5

=IF(A4="",A5<"",IF(A4<"",A54,""))



On Oct 29, 10:57 pm, jpreman
wrote:
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