Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pablo Picasso
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dates in Formula John G Excel Discussion (Misc queries) 10 January 15th 05 03:48 PM
How do I format dates accessed by a formula Mont22 Excel Discussion (Misc queries) 2 January 12th 05 04:09 PM
due dates Niki New Users to Excel 4 January 10th 05 04:11 PM
Logical formula with dates Peo Sjoblom Excel Worksheet Functions 1 December 27th 04 05:15 PM
Logical Text Formula Jim Excel Worksheet Functions 2 December 6th 04 10:37 PM


All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"