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

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

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

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

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

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

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

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