I have a spreadsheet which is created from a access 97 dump, it puts a
contract date and a promise date in, this is sent to the vendor who
puts in a forecast date. I have done an IF statement that says
=IF(c1=d1,"ok","why"). The problem is that when you type in the
forecast date even though it matches it does not work. Tried to format
the cells to date, cut the cells changed the format then pasted them
back in.
The only way it works is if you change the format and then double click
on the cell, then enter the forecast date this then works.

Why does this happen and also what is the way round it.