View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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