How do I set up a cell to input a date 1 year from another cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm entering training dates in Excel. The recertification date is one year
from the original date. I want the recert. due date to enter itself when I
input original date. Original dates are one row, recerts are another.
 
=A1+365 assuming the original date is in cell A1

assuming you're not too worried about Leap Years, etc

Regards

Trevor
 
If you are concerned about leap years then try:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top