| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you calculate the number of years between two dates in Excel 0
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you calculate the number of years between two dates in Excel 0
=DATEDIF(StartDate,EndDate,"y")
See http://www.cpearson.com/Excel/datedif.aspx for details about DATEDIF. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 3 Dec 2008 14:48:12 -0800, Christina wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you calculate the number of years between two dates in Excel 0
I assume you want full calendar years:
A1 = start date B1 = end date =DATEDIF(A1,B1,"y") -- Biff Microsoft Excel MVP "Christina" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you calculate the number of years between two dates in Excel 0
Hi,
As a best practise, please ensure that the year is always 4 digits. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Christina" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you calculate the number of years between two dates in Excel 0
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)) -- If this helps, please click the Yes button Cheers, Shane Devenshire "Christina" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I calculate a difference in dates in years and months? | Excel Discussion (Misc queries) | |||
| how do I calculate years between two dates | Excel Discussion (Misc queries) | |||
| How do I calculate the number of years between 2 dates | Excel Discussion (Misc queries) | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| HOW TO CALCULATE THE NUMBER OF YEARS BETWEEN TWO DATES | Excel Worksheet Functions | |||
Linear Mode
