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

[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.

 

[Guest]

=A1+365

If your dates were starting in A1 try this formula in B1

 

[Trevor Shuttleworth]

=A1+365 assuming the original date is in cell A1

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

Regards

Trevor

 

[Sandy Mann]

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