ExcelBanter - how to get auto next due date for the renewal of some document

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!

--------------------
(Ms-Exl-Learner)
--------------------

"Farida" wrote:

eg. to get next servicing date for the Vehicle.