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

's Computer Specifications

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.

's Computer Specifications

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

's Computer Specifications

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

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

Regards

Trevor

"wyrmslair" <(E-Mail Removed)> wrote in message
news:869CD807-BC71-404E-A8E3-(E-Mail Removed)...
> 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.

's Computer Specifications

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 Removed)
(E-Mail Removed) with @tiscali.co.uk

"wyrmslair" <(E-Mail Removed)> wrote in message
news:869CD807-BC71-404E-A8E3-(E-Mail Removed)...
> 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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting Year from date cell	=?Utf-8?B?Qm9i?=	Microsoft Excel Programming	4	30th Aug 2007 03:46 PM
extract year from the date in a cell	DKY	Microsoft Excel Worksheet Functions	7	17th Mar 2006 07:07 PM
Conditional formatting - different cell colour for each year following from user input date?	StargateFan	Microsoft Excel Programming	20	11th Jan 2006 07:11 AM
how do i add 1 year to a date formatted cell?	=?Utf-8?B?cm9nZXJt?=	Microsoft Excel Worksheet Functions	5	4th Sep 2005 06:46 AM
data validation to restrict input in cell based on value of cell above that cell	NC	Microsoft Excel Programming	2	25th Jan 2005 07:11 AM