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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wyrmslair - 13 Jun 2006 20:36 GMT

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.

Reply to this Message

Tim M - 13 Jun 2006 20:56 GMT

=A1+365

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

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

Reply to this Message

Trevor Shuttleworth - 13 Jun 2006 20:56 GMT

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

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

Regards

Trevor

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

Reply to this Message

Sandy Mann - 13 Jun 2006 21:21 GMT

If you are concerned about leap years then try:

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

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

Reply to this Message