formula for scheduling in advance

[laurel]

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.

 

[Kevin B]

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

 

[Dave Peterson]

or even:

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

(just adds 1 year)