Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to advance dates by one year then up to 10 yrs in Excel
Doing an amortization table beginning with 10/2007 want to quickly advance
the dates quarterly for the next 10 years. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to advance dates by one year then up to 10 yrs in Excel
What do you want, to advance 3 months or a year like you state in your
subject line If you have a date in A1 then you can add 3 months like this =DATE(YEAR(A1),MONTH(A1)+3,Day(A1)) do the same with a year =DATE(YEAR(A1)+1,MONTH(A1),Day(A1)) now depending on the day of the month you can get unexpected results for instance if the date you want to add 3 months to is 11/30/07 then the date will come out as 03/01/08. There are remedies for this if you want the last date of February instead. =MIN(DATE(YEAR(A1),MONTH(A1)+{3,4},DAY(A1)*{1,0})) -- Regards, Peo Sjoblom "chaplyn" wrote in message ... Doing an amortization table beginning with 10/2007 want to quickly advance the dates quarterly for the next 10 years. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to advance dates by one year then up to 10 yrs in Excel
Depends on "exactly" what you want as a result..........
This, copied down column A would give equal time periods of "about 3 months" =A1+365.25/4 Vaya con Dios Chuck, CABGx3 "chaplyn" wrote: Doing an amortization table beginning with 10/2007 want to quickly advance the dates quarterly for the next 10 years. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates ... advance 1 Month @ a Time | Excel Discussion (Misc queries) | |||
how to creat a formula to advance date by one year | Excel Worksheet Functions | |||
how do I convert a dates in a year quarters in a year? | Excel Discussion (Misc queries) | |||
How can I use day of year dates in Excel? | Excel Discussion (Misc queries) | |||
how do I set dates every 3 cell for whole year in excel | Excel Discussion (Misc queries) |