Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Logical formula with dates
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates in Formula | Excel Discussion (Misc queries) | |||
How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
Logical formula with dates | Excel Worksheet Functions | |||
Logical Text Formula | Excel Worksheet Functions |