IF Statement

**lostatsea** · 04-23-2007, 03:03 PM

I would like to track a due date for an item in my worksheet.
The due date is 15 years from a start date referenced in another cell, and it recurs every 15 years.

I have a calculation that creates warning dates leading up to that deadline (1 year, 6 months, 3 months, 1 month). What I would now like to do is to make that due date cell smart enough to know whether the result is less than<today's date, or greater than>today's date. If it is less than<today's date it has already happened in the past and is of no more use to me. I would like it to find the next logical due date based on a 15 year cycle. I have already figured out the 'then' part of the statement. I am simply looking for the next due date based on the originating date with 15 year cycles.

It's simpler than it sounds, I know

**oldchippy** · 04-23-2007, 05:03 PM

If you have your start date in A1, for example 01/01/1990, then in B1

=IF(DATE(YEAR($A$2)+15,MONTH($A$2),DAY($A$2))<TODAY(),"This date has passed",DATE(YEAR($A$2)+15,MONTH($A$2),DAY($A$2)))

and in C1

=IF(DATE(YEAR($A$2)+30,MONTH($A$2),DAY($A$2))<TODAY(),"This date has passed",DATE(YEAR($A$2)+30,MONTH($A$2),DAY($A$2)))

**lostatsea** · 04-24-2007, 09:38 AM

Hey, thanks for your reply. What if the 30 years is added, but still falls short of today, do I add another string with 45 and 60 and so on? I think 60 would be max.