Assume that you are having a date in A1 cell
A1
17/11/2009
If you want to get the renewal date for the next 30 days
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+30)
Result = 17/12/2009
In the above formula just added the number of days next to the Day cell
reference. Like that you can add the Month and year occurrences also.
Formula to get the Renewal Date (Next 6 Months).
=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
Result: 17/05/2010
Formula to get the Renewal Date (Next 3 Years).
=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))
Result: 17/11/2012
Instead of referring the date in A1 cell you can mention the current date in
formula itself.
Next 30 Days:-
=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+30)
Next 6 Months:-
=DATE(YEAR(TODAY()),MONTH(TODAY())+6,DAY(TODAY()))
Next 3 Years:-
=DATE(YEAR(TODAY())+3,MONTH(TODAY()),DAY(TODAY()))
Hope this is what you required.
If this post helps, Click Yes!
