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......