Year Totals

N

nancelsb

I need to figure out how to find the difference in years down to a decimnal
point. for example .....11-01-02 minus 04-16-85 = 17.6 years. Does any one
know how to create a formula that can do this for me??? Thank you.
 
C

CLR

Using your dates in A1 and B1, this formula will return 17.6 in a cell
formatted for numbers with one decimal place.............

=(A1-B1)/365

Vaya con Dios,
Chuck, CABGx3
 

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

Modifying a complex date formual to count months 4
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Sum value between two dates and copy to new cell 7
need formula to pick a value every certain set of minutes from large database 2
Financial Time Value of Money calculations 5
help with Sum in between dates 12
Lookup and count all cells that fall between 2 dates 3
Linking Child Timelines to Multiple Parents 0

Top