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

W

wyrmslair

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

Trevor Shuttleworth

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

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

Regards

Trevor
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Pass date from one form to another form in MS Access 1
Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Show value from one cell in another cell if today falls between a date range 5
Would like to input 3 letters into a cell, each having a different numerical value 5
Reminder notification for training 2
How do I clear a form? 0
Referrence a total in a cell on another worksheet 4

Top