How do I set up a cell to add 12 months to the date in another cell?
Example: 'Maint Date' cell has current date--'Next Maint Due' cell needs to
have that date plus 12 months.

If your date is in cell A1 and the formula is in B1 it would look like this:

DATE(YEAR(A1),MONTH(A1)+12,DAY(A1))

Adjust the cell address as needed
--
Kevin Backmann


"laurel" wrote:

How do I set up a cell to add 12 months to the date in another cell?
Example: 'Maint Date' cell has current date--'Next Maint Due' cell needs to
have that date plus 12 months.

or even:

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

(just adds 1 year)

laurel wrote:

How do I set up a cell to add 12 months to the date in another cell?
Example: 'Maint Date' cell has current date--'Next Maint Due' cell needs to
have that date plus 12 months.

--

Dave Peterson