It sounds like the *dates* you have are really text representations of dates
not real dates. Try pretending to reformat one of the cells to General and
it should show a value like 39493 in the Format cells dialog box. If it
still shows the date then it means that it is text.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Annie" wrote in message
...
I am putting in the formula exactly as suggested but keep getting #VALUE!
in
the cell. I have checked it many times and it is the correct formula.
--
Kind regards
Ann Shaw
"Jarek Kujawa" wrote:
in C1
=IF(B1-A1<=30,"<=30 days overdue",IF(AND(B1-A130,B1-
A1<=60),"30<overdue<=60",IF(AND(B1-A160,B1-
A1<=90),"60<overdue<=90","90 days overdue"))))
copy down, then apply autofilter