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