| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increase date by 1 year
In Excel 2003, how can I build a formula to increase each subsequent date in
a column by one year (not 365 days) when the first date in the column is changeable. Thanks...jcs |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase date by 1 year
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Craig" wrote in message . .. In Excel 2003, how can I build a formula to increase each subsequent date in a column by one year (not 365 days) when the first date in the column is changeable. Thanks...jcs |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase date by 1 year
Assuming your changeable date is in A1, enter this formula in A2:
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) Copy down as far as needed. HTH, Elkar "Craig" wrote: In Excel 2003, how can I build a formula to increase each subsequent date in a column by one year (not 365 days) when the first date in the column is changeable. Thanks...jcs |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase date by 1 year
What if the beginning column format date is 8/1/07 where the year, month and
day are not segregated? "Bernard Liengme" wrote in message ... =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Craig" wrote in message . .. In Excel 2003, how can I build a formula to increase each subsequent date in a column by one year (not 365 days) when the first date in the column is changeable. Thanks...jcs |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase date by 1 year
If it is real Excel date, then Excel will find yy, mm and dd no matter what
format is used. Did you try it? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Craig" wrote in message . .. What if the beginning column format date is 8/1/07 where the year, month and day are not segregated? "Bernard Liengme" wrote in message ... =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Craig" wrote in message . .. In Excel 2003, how can I build a formula to increase each subsequent date in a column by one year (not 365 days) when the first date in the column is changeable. Thanks...jcs |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase date by 1 year
Actually it worked based on your original suggestion
(=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1) ). Sorry I must have entered the formula incorrectly at first. This was a great and simple solution. Thanks again...jcs "Bernard Liengme" wrote in message ... If it is real Excel date, then Excel will find yy, mm and dd no matter what format is used. Did you try it? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Craig" wrote in message . .. What if the beginning column format date is 8/1/07 where the year, month and day are not segregated? "Bernard Liengme" wrote in message ... =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Craig" wrote in message . .. In Excel 2003, how can I build a formula to increase each subsequent date in a column by one year (not 365 days) when the first date in the column is changeable. Thanks...jcs |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a year date into a specific day date | Charts and Charting in Excel | |||
| Help w/formula to add 1 year to cell (date done) date due? | Excel Worksheet Functions | |||
| pick up date, month and year from a date | Excel Discussion (Misc queries) | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Linear Mode
