Excel 2003. I have two cells with dates A1, B1
I'm trying to compare the dates with results in cell C1 using:
However my results are always "A". I've tried the date in mm/dd/yyyy and mm-dd-yyyy with no change in the results.
I believe I have compared dates like this before. In ideas why this is not working?