Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to add 12 months to an existing date field
I am a novice Excel user. In field A1 I have the date 12/1/08. I would like
to know a formula that automatically would add 12 months to this date i.e. 12/1/09 in field A2. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to add 12 months to an existing date field
Check your first post
"Steve 084" wrote: I am a novice Excel user. In field A1 I have the date 12/1/08. I would like to know a formula that automatically would add 12 months to this date i.e. 12/1/09 in field A2. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to add 12 months to an existing date field
One way:
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) Note that if A1 = 2/29/08, the formula will return 3/1/09. In article , Steve 084 wrote: I am a novice Excel user. In field A1 I have the date 12/1/08. I would like to know a formula that automatically would add 12 months to this date i.e. 12/1/09 in field A2. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to add 12 months to an existing date field
=date(year(a1)+1,month(a1),day(a1))
If the date is February 29, then you'll get March 1, though. Steve 084 wrote: I am a novice Excel user. In field A1 I have the date 12/1/08. I would like to know a formula that automatically would add 12 months to this date i.e. 12/1/09 in field A2. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to add six months to date | Excel Worksheet Functions | |||
Formula subtracting months from a set date | Excel Discussion (Misc queries) | |||
formula to calculate age at a given date in years and months? | Excel Discussion (Misc queries) | |||
I want to add 6 months to a certain date in a formula (Excel) | Excel Worksheet Functions | |||
Formula: Date plus 3 months | Excel Discussion (Misc queries) |