Adding 5 yrs to and existing date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column with several dates:

09/24/2003
03/17/2001
01/22/1998

In the next column, I want 5 yrs added. Is there a formual that could give
me the following results:
09/24/2008
03/17/2006
01/22/2003

Thanks for your time.
 

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

Convert Date and Time 9
Find then highlight in yellow 6
Duplicate a set of rows for each item (subdatasheet?) 0
Update by most recent date 2
separating date and time 5
Advanced problem using auto-number and datediff to find readmissio 1
How to get largest date from a Vlookup 1
Date Function 2

Back
Top