Conditional format a cell based on a due date

**Taiter** · 07-15-2013, 10:44 PM

Greetings,
I am trying to apply a conditional format to a cell that is based on a date. I need the condition to apply when that date entered is within 24 months and again within 21 months.

Any suggestions on the formula to use?

Thank you,
Taiter

**FDibbins** · 07-15-2013, 10:59 PM

Not sure where you want this, but this should give you the basic concept of how to do what you want....

=C1<=TODAY()+DATE(0,24,0)

**Taiter** · 07-15-2013, 11:14 PM

Just to make sure I understand the formula - The Date(0,24,0) is actually Date(day, month, year)? This is going to be used to track training and each course has a recurring requirement (e.g. some courses are every 2 years, some are annual, etc). So do I substitute the + for a -? Also do I really need to have the Today() statement since it will based on the date entered in the cell?

Thank you for the quick reply.

**FDibbins** · 07-15-2013, 11:50 PM

no, =date(year,month,day) If you enter =date(...or any formula for that matter, excel will show you the syntax it expects.

I included TODAY() to give it a reference. for instance if you enter 6/15/2015 into C1, what would you compare it against to determine the <= 24 months? If you have another date you will compare it against, then use that instead

I am adding the DATE() value to TODAY() so that it has something to compare with. If your date (that the training last happened on) is in the past, then you would change the forumla to...
=C1>=TODAY()-DATE(0,24,0)