| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add Months to a date??
Hi,
How do I get Excel to add a certain number of months to a date?? For example if cell A1 I have the date 7th February 2007 and in cell B1 I had 18 (the number of months I wanted to add) What formula would I have to put in cell C1 so that it adds 18 months to 7th February 2007, thus giving the answer 7th August 2008? Any help would be appreciated! Thank you & kind regards, Dal |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add Months to a date??
Hi,
=A1+DATE(0,B1,0) Cheers! Jean-Guy "Dal1981" wrote: Hi, How do I get Excel to add a certain number of months to a date?? For example if cell A1 I have the date 7th February 2007 and in cell B1 I had 18 (the number of months I wanted to add) What formula would I have to put in cell C1 so that it adds 18 months to 7th February 2007, thus giving the answer 7th August 2008? Any help would be appreciated! Thank you & kind regards, Dal |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add Months to a date??
Guess I should have paid more attention to the result, short by 1 month so:
=A1+DATE(0,B1+1,0) but I would go with John's answer. Regards! Jean-Guy "pinmaster" wrote: Hi, =A1+DATE(0,B1,0) Cheers! Jean-Guy "Dal1981" wrote: Hi, How do I get Excel to add a certain number of months to a date?? For example if cell A1 I have the date 7th February 2007 and in cell B1 I had 18 (the number of months I wanted to add) What formula would I have to put in cell C1 so that it adds 18 months to 7th February 2007, thus giving the answer 7th August 2008? Any help would be appreciated! Thank you & kind regards, Dal |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add Months to a date??
Closer, but can still be a few days adrift, for example when adding 18
months to 28 Aug 2007, your new formula gives 25 Feb 2008. -- David Biddulph "pinmaster" wrote in message ... Guess I should have paid more attention to the result, short by 1 month so: =A1+DATE(0,B1+1,0) but I would go with John's answer. "pinmaster" wrote: Hi, =A1+DATE(0,B1,0) "Dal1981" wrote: Hi, How do I get Excel to add a certain number of months to a date?? For example if cell A1 I have the date 7th February 2007 and in cell B1 I had 18 (the number of months I wanted to add) What formula would I have to put in cell C1 so that it adds 18 months to 7th February 2007, thus giving the answer 7th August 2008? Any help would be appreciated! Thank you & kind regards, Dal |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add Months to a date??
You are absolutely right! Thanks for pointing that out!
Regards! Jean-Guy "David Biddulph" wrote: Closer, but can still be a few days adrift, for example when adding 18 months to 28 Aug 2007, your new formula gives 25 Feb 2008. -- David Biddulph "pinmaster" wrote in message ... Guess I should have paid more attention to the result, short by 1 month so: =A1+DATE(0,B1+1,0) but I would go with John's answer. "pinmaster" wrote: Hi, =A1+DATE(0,B1,0) "Dal1981" wrote: Hi, How do I get Excel to add a certain number of months to a date?? For example if cell A1 I have the date 7th February 2007 and in cell B1 I had 18 (the number of months I wanted to add) What formula would I have to put in cell C1 so that it adds 18 months to 7th February 2007, thus giving the answer 7th August 2008? Any help would be appreciated! Thank you & kind regards, Dal |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add Months to a date??
That formula gives 8th July 2008, so you're about a month adrift.
If you want 7th August 2008, try =DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)) -- David Biddulph "pinmaster" wrote in message ... Hi, =A1+DATE(0,B1,0) "Dal1981" wrote: Hi, How do I get Excel to add a certain number of months to a date?? For example if cell A1 I have the date 7th February 2007 and in cell B1 I had 18 (the number of months I wanted to add) What formula would I have to put in cell C1 so that it adds 18 months to 7th February 2007, thus giving the answer 7th August 2008? Any help would be appreciated! Thank you & kind regards, Dal |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add Months to a date??
try putting =EDATE(A1,B1) in cell c1
"Dal1981" wrote: Hi, How do I get Excel to add a certain number of months to a date?? For example if cell A1 I have the date 7th February 2007 and in cell B1 I had 18 (the number of months I wanted to add) What formula would I have to put in cell C1 so that it adds 18 months to 7th February 2007, thus giving the answer 7th August 2008? Any help would be appreciated! Thank you & kind regards, Dal |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add Months to a date??
Thanks John, this seems to have done the trick!!
Thanks also to Jean-Guy and David! Kind regards, Dal "john the confused" wrote: try putting =EDATE(A1,B1) in cell c1 "Dal1981" wrote: Hi, How do I get Excel to add a certain number of months to a date?? For example if cell A1 I have the date 7th February 2007 and in cell B1 I had 18 (the number of months I wanted to add) What formula would I have to put in cell C1 so that it adds 18 months to 7th February 2007, thus giving the answer 7th August 2008? Any help would be appreciated! Thank you & kind regards, Dal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sick time accumulation | Excel Worksheet Functions | |||
| How can I find the greatest possible sum within 12 months? A newbie... | Excel Worksheet Functions | |||
| insert date | Excel Worksheet Functions | |||
| X-Y Graph with Months, Not Date on Axis | Excel Discussion (Misc queries) | |||
| Use a calc to figure sum in months using date fields but numeric r | Excel Worksheet Functions | |||
Hybrid Mode
