Calculate 6 Months

I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths
automatable for anther date. The mouths need to be consecutive. IE in one
cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005

Please explain why six months added to 1/29/2005 is 6/1/2005

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jason" <Jason@discussions.microsoft.com> wrote in message
news:4682E24E-7EF3-449E-ABB6-B52B0C660B1B@microsoft.com...
>I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths
> automatable for anther date. The mouths need to be consecutive. IE in one
> cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005

The date 6/1/2005 isn't 6 months after 1/29/2005, was that a typo?

If you want to calculate 6 months after a date use this formula, assume your
old date is in A1:

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))

Also, do you need it to produce the first day of the month which is 6 months
out? In that case use this:

=DATE(YEAR(A1),MONTH(A1)+6,1)

Does that help?
--
Regards,

Dave


"Jason" wrote:

> I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths
> automatable for anther date. The mouths need to be consecutive. IE in one
> cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005

Perhaps this is what you want.....assuming your starting date is in A1

=(MONTH(A1)+6)&"/"&1&"/"&YEAR(A1)

Vaya con Dios,
Chuck, CABGx3



"Jason" wrote:

> I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths
> automatable for anther date. The mouths need to be consecutive. IE in one
> cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005

1/30-31 one mouth, 2/1-28 2mouth, 3/1-31 3mouth, 4/1-30 4mouth ,5/1-31
5mouth, 6/1-30 6mouth,

"Bernard Liengme" wrote:

> Please explain why six months added to 1/29/2005 is 6/1/2005
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Jason" <Jason@discussions.microsoft.com> wrote in message
> news:4682E24E-7EF3-449E-ABB6-B52B0C660B1B@microsoft.com...
> >I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths
> > automatable for anther date. The mouths need to be consecutive. IE in one
> > cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005
>
>
>

Formulawise with 1/29/2005 in A1;
enter in B1
=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))


B1 uses the same Year, the same day
but for the month it adds 6, << this
in order to get what you want.

otherwise 6 months from 1/29/2005 IS 6/01/2005.


"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:%23sDM9NApFHA.320@TK2MSFTNGP09.phx.gbl...
> Please explain why six months added to 1/29/2005 is 6/1/2005
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Jason" <Jason@discussions.microsoft.com> wrote in message
> news:4682E24E-7EF3-449E-ABB6-B52B0C660B1B@microsoft.com...
>>I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths
>> automatable for anther date. The mouths need to be consecutive. IE in
>> one
>> cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005
>
>