|May be coz its text.|
The formula will not work on TEXT, you will have to convert the text string date
into a real date.
How is your date written?
You can use the =DATEVALUE() function
and it will usually convert a text value
that looks like a Date into a real Date.
With your Text Date in cell A1
in cell B1 you would enter the formula: =DATEVALUE(A1)
See how that works.
If you end up with a 5 digit number,
reformat the cell to a Date Format.
message edited by mmcconaghy