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

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.

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

=A1+365

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

"wyrmslair" wrote:

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.

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

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

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

Regards

Trevor


"wyrmslair" wrote in message
...
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.

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

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


with @tiscali.co.uk


"wyrmslair" wrote in message
...
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.