With some date in A1, use:

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

--
Gary''s Student - gsnu200838


"DaveKid" wrote:

Hi, I would like to be able to produce a date which is automatically 3 months
ahead of a date in another cell. How do I do this?