Originally Posted by
martindwilson
well that's your problem..that is a text date if it was a real date it would show as 41162 which is the date code for 10/09/2012
text is always greater than a number hence FALSE
either delete b9 change the format to general and re-nter the date (it should then get recognised and format itself automatically) or if you have a column of dates in the same format
select the column
go to data tab
text to columns
click next
click next again
and assuming dates are d/m/y
choose date option and use the drop down to set to DMY
click finish
now you should have real dates
Bookmarks