If the outcome of Max's formula is a blank, then you haven't got real dates
in your 2 input cells.
Check your data.
--
David Biddulph

"trevor" wrote in message
...
Thank again for your reply, but i'm still getting no joy with this,
Maybe I am explaining it wrongly to you!
Now when I try your statement its outcome is nothing, blank.

But I understand your way abit clearer, however is they any chance of
getting a contact add so I can show what I am doing?

thanks

"Max" wrote:

The front IF check:
=IF(COUNT(A13,C13)<2,"", ...
is just an added precaution to ensure that *both* A13 and C13 do contain
real dates (real dates are numbers) before proceeding with the rest of
the IF
evaluations, otherwise spurious/meaningless results might arise since
blank
cell/s are evaluated as zeros in expressions.

For example, if A13 was blank, then: IF(TODAY()A13 would always evaluate
to
TRUE, which would be a spurious/meaningless result, no? Similarly for C13
&
the check: IF(TODAY()C13.

When you plugged the entire expression in, did it return the expected
results?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"trevor" wrote:
Hi max

Thanks for your revised statement.
However I did not understand it properly a little confussed!
Especially the count bit!

I am try to auto input the following:
Overdue to appear if the date is after the agreed date
Open to appear if within the agreed date
closed if data is in any of the closed colums (3)
but offten it is entered the 'closed date colum'

I want to appear in the either closed, open or overdue