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

"Max" wrote:

Your IF construct was not correct
Try this revision:
=IF(COUNT(A13,C13)<2,"",IF(TODAY()A13,"OVERDUE",I F(TODAY()C13,"CLOSED","OPEN")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"trevor" wrote:
Hi All

I am writing a formula to return 3 values, using 2 IF statement.

=IF(TODAY()A13,"OVERDUE","OPEN"),IF(TODAY()C13," CLOSED")
But for some reason it keeps on returning an error message #value!

Cell A13 & C13 contains dates, formmatted!
Do i need to unformat the dates to read better? ie: 38143 = 06/06/2008

Also I have two other cell which can determin the closed date, which you
enter the either a two figure number or another cell with a year date (ie:
2007-2008)

Thanks