Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW TO CALCULATE THE NUMBER OF YEARS BETWEEN TWO DATES
I WANT TO CALCULATE THE #S OF YEARS BETWEEN TWO DATES
|
#2
|
|||
|
|||
=DATEDIF(B1,A1,"y")
Where A1 is today, And B1 is a past date. Check out Chip Pearson's web page on this "Un-Documented" function: (Except in XL2K) http://www.cpearson.com/excel/datedif.htm -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RAMON" wrote in message ... I WANT TO CALCULATE THE #S OF YEARS BETWEEN TWO DATES |
#3
|
|||
|
|||
Ramon
With earliest date in A1 and later date in B1 In C1 enter =DATEDIF(A1,B1,"y") & " years" Gord Dibben Excel MVP On Sun, 20 Feb 2005 16:41:04 -0800, "RAMON" wrote: I WANT TO CALCULATE THE #S OF YEARS BETWEEN TWO DATES |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
calculate number of years | New Users to Excel | |||
Calculate months and years | Excel Discussion (Misc queries) | |||
calculate month from week number | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |