Hi,

I have extracted date information from various different databases and wish
to determine which are greater than a certain date. Now, I can write the IF
statement (IF(G2J1,True,False), but it doesn't seem to be working correctly,
it gives all dates as True, even when they are less than my cutoff date.

I think that there could be a problem with my imported dates, but I cannot
convert them using DATEVALUE - some convert, some give the #VALUE error.
If I convert using =TEXT(G2,"dd/mm/yyyy"), I still can't either work the IF
statement, or use DATEVALUE!

A problem is I'm not sure exactly how the date info is held in the databases,

Help, I think I'm going mad.....

Charlotte