formula for recurring expire date

Hello,

I am trying to figured out formula to determine expire date of annual leave.

example:

I hired on Dec 1, 2013
my annual leave will be expire after 3 month from hired month on current year (2015), which is March 2016.

I wonder if i can use formula in one single cell rather than two cells as attached example.

Thank you.

Hi,

Thank you for your help.

But i am afraid that will not work.

as you can see, EDATE(H3,3) will give 3 month which return to March 2014 ( not valid year).

I need a dynamic formula that will return to March 2016 for this year, and for next year will automatically change to March 2017 and so on, as after it expire, it will reset until next year expire date.

Thank you.

For expire date
=DATE(YEAR(TODAY()),MONTH(H3)+3,1)

For month left
=IF(MONTH(J3)<MONTH(TODAY()),MONTH(J3)+12-MONTH(TODAY()),MONTH(TODAY())-MONTH(J3))

Thank you FlameRetired, yes it work with datedif, minor change, "md" to "ym" as "md" to count days not months.

Final formula for expire date that worked for me:

=IF(I3-DATE(YEAR(TODAY());MONTH(H3)+3;1)<0;DATE(YEAR(TODAY());MONTH(H3)+3;1);DATE(YEAR(TODAY());MONTH(H3)+15;1))

Thank you all for your help. really appreciate