ExcelBanter - if function with dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if function with dates (https://www.excelbanter.com/excel-discussion-misc-queries/3477-if-function-dates.html)

Brad

if function with dates

I am trying to combine an if function with dates:

my formula reads: =IF(C2<"10/01/04",B2,"")

It is not working...can anyone help?

Dave O

It worked for me when I changed it slightly:
=IF(C2<DATEVALUE("10/01/04"),B2,"")

I think previously Excel was performing a text comparison, rather than
a date comparison.

All times are GMT +1. The time now is 06:20 AM.