Data Validation with two criteria's

[tlc53]

Hi,

I can not for the life of me work out why this data validation code is not working?!?

=OR(F8="Enter YE Date",F8=EOMONTH(F8,0))

The second part works, allowing only a month end date to be entered, but it will not let you enter text "Enter YE Date". I'm setting this under Custom/Formula under Data Validation.

Thanks

 

[etaf]

its the F8=EOMONTH(F8,0)) part , as that will return value error , when NOT a date entry

=OR(F8="Enter YE Date",IF(ISNUMBER(F8),F8=EOMONTH(F8,0)))

 

[kvsrinivasamurthy]

Try This

=IF(ISNUMBER(F8),F8=EOMONTH(F8,0),F8="Enter YE Date")

 

[tlc53]

Try This

=IF(ISNUMBER(F8),F8=EOMONTH(F8,0),F8="Enter YE Date")

Awesome! Thank did the trick. Thank you.