If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to get auto next due date for the renewal of some document
eg. to get next servicing date for the Vehicle.
|
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|