Excel formula to figure out expiration date in the future

**AQUANX4** · 03-05-2013, 01:04 AM

Good Morning my friends. I hope you are all well. I have a simple question (hopefully). Here is my formula:

=IF(AD2<(TODAY()+26)-365,"YES","NO"))

As you can see, this formula figures out if on April 1st, 2013, the date in AD2 is outside of 12 months. Now, this is my question. How can I figure out if the date in AD2 will be outside of 12 months for the whole month of April, 2013? Right now I have it adding 26 days to figure out the logic for April 1st, 2013. How do I get it to evaluate for April 1st, 2013 thru April 30th, 2013?

Hope you can understand what I am asking......

**dilipandey** · 03-05-2013, 01:30 AM

Hi Aquanx4,

welcome to the forum.
Today, you are in March... so do you wish to know that on the 1st April 2013, the date (today()) will be outside of 12 months ? if yes. which 12 months... passed ones or future ones ?

Regards,
DILIPandey
<click on below * if this helps>

**AQUANX4** · 03-05-2013, 01:49 AM

Thank you Sir for responding. Yes, I would like to figure out if the date I input in field AD2 will be outside of 12 months (like expiration date). However, I was trying to figure out if the date will be expired from the future dates = April 1st, 2013 thru April 30th, 2013. Does that make sense?

**dilipandey** · 03-05-2013, 09:05 AM

I would like to figure out if the date I input in field AD2 will be outside of 12 months

which 12 months ?

Example..I can enter today's date (5-Mar-2013 in AD2) now which 12 months to look for ? and which date to which date ? where is this information in your excel sheet ? thx

Regards,
DILIPandey
<click on below * if this helps>