Enter a formula that calculates 5 years from a given date

G

Guest

I have a cell with a date (10/01/2004) and I want to calculate 5 years from
that date (09/30/2009) - is there a formula in excel to do that?

I am using Excel 2003.
 
F

Frank Kabel

Hi
without taking into account leap years and adding 5 years to
29-Feb-2004 try:
=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))
 

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

Scrabble Value calculation for Welsh words 0
Date lists 3
possible countif formula? 3
Project a date and calculate a % in one formula 4
Calculation of Quarter 16
Countifs of prior years monthly data based on MTD today 3
Calculate within a time range with only start date and end date 2
Count based on date criteria 1

Top