Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do get the years and days Between two dates
if you had 5/1/2006 and 2/28/2002 how would you get 4.17?
|
#2
|
|||
|
|||
If 5/1/2006 is in A1 and 2/28/2002 is in A2, then maybe:
=(a1-a2)/365 or =(a1-a2)/365.25 But if you're trying to find differences between dates, you may want to take a look at =datedif(). You can find lots of info at Chip Pearson's site: http://www.cpearson.com/excel/datedif.htm (=datedif() was only documented in xl2k's help.) jhon doe wrote: if you had 5/1/2006 and 2/28/2002 how would you get 4.17? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
Number of years, months, days between two dates. | Excel Worksheet Functions | |||
difference between two dates in years, months and days. | Excel Worksheet Functions | |||
Brainteaser about Days Between Dates | Excel Discussion (Misc queries) | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions |