Excel IF formula and dates...HELP!

[funkylad20]

I have a list of dates over an entire year.
I want to say 'if a date falls before a set date of 30/06/2010, return a 'YES'. If not, return a 'NO'.
Any ideas?!

[SpodoCommodo]

Possibly (i don't have Excel to experiment) - isn't a date field basically a numeric value and so you can use a simple 'if A<B' type comparison? (you'd could have a cell containing the date that you want to use and compare with the value contained therein, or just use it temporarily to get the date value)

Only the other hand that ^^^ might be a completely wrong and there's some very simple way to do it.

[SpodoCommodo]

p.s. there is DateValue() which returns the serial number of a date for use in a comparison (and it wouldn't be necessary to use another cell just for required date.)

[rojash]

=IF(A5<DATEVALUE("30/06/2010"),"YES","NO")