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" wrote in message
...
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" wrote in message
...
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