formula for scheduling in advance
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
|