Can you calculate the number of years between two dates in Excel 0

C

Christina

Can you calculate the number of years between two dates in Excel 2003?

Ie. What is the total number of years between 9/21/1992 and 1/10/09?
 
T

T. Valko

I assume you want full calendar years:

A1 = start date
B1 = end date

=DATEDIF(A1,B1,"y")
 
S

Shane Devenshire

Hi,

You can also use

=YEARFRAC(A1,A2)

Where A1 is a start date and A2 is the end date. Note this will return
something like 10.234 so if you don't want/need the fractional part you can
modify this to read

=TRUNC(YEARFRAC(D9,D10))
 

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

Calculating number of workdays between 2 dates 14
Calculate elapsed time excluding specific timeframe 10
NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET 2
calculate month 9
Calculating number of weeks between dates? 2
Number of Weekend Days between 2 Dates Q 1
How do I calculate exact difference between two dates in y,m,d. 6
Excel DateDif - why does 2007 seem different? 3

Top