Logical formula with dates
 

First of all, no need to use TRUE here, also no need to make 2005 or 2004 as
text by enlsoing them in quotes, this should work

=IF(ISBLANK(E3),"",IF(E3="TBD",2005,IF(E3--"1/15/2005",2005,IF(E3<=--"1/15/2005",2004,""))))


could be rewritten as

=IF(ISBLANK(E3),"",IF(OR(E3="TBD",E3--"1/15/2005"),2005,2004))

Regards,

Peo Sjoblom

"Pablo Picasso" wrote:

I am trying to use the following formula to determine wether an event has
occurred in 2004 (when it was scheduled) or if it will be pushed to 2005
(after 1/15/05), anything with a TBD needs to be pushed to 2005, and any
blank cells should be ignored. The formula is breaking when any date with
2004 appears.

=IF((ISBLANK(E3))=TRUE,"",IF(E3="TBD","2005",IF(E3 1/15/2005,"2005",IF(E3<=1/15/2005,"2004",""))))

here is a look at the spreadsheet:
A B C D E
1 Store Project Start End Actual
2 Atlanta Remodel 10/26/04 1/15/05 2005
3 Reset TBD TBD 2005
4
5 Chicago Remodel 9/21/04 12/15/04 2005
6 Reset TBD TBD 2005

when I pasted the formula in to a shorter version to copy the formula
references were transposed, the formula should read:

=IF((ISBLANK(D3))=TRUE,"",IF(D3="TBD","2005",IF(D3 1/15/2005,"2005",IF(D3<=1/15/2005,"2004",""))))

The formula appears in the "E" column...

"Pablo Picasso" wrote:

I am trying to use the following formula to determine wether an event has
occurred in 2004 (when it was scheduled) or if it will be pushed to 2005
(after 1/15/05), anything with a TBD needs to be pushed to 2005, and any
blank cells should be ignored. The formula is breaking when any date with
2004 appears.

=IF((ISBLANK(E3))=TRUE,"",IF(E3="TBD","2005",IF(E3 1/15/2005,"2005",IF(E3<=1/15/2005,"2004",""))))

here is a look at the spreadsheet:
A B C D E
1 Store Project Start End Actual
2 Atlanta Remodel 10/26/04 1/15/05 2005
3 Reset TBD TBD 2005
4
5 Chicago Remodel 9/21/04 12/15/04 2005
6 Reset TBD TBD 2005