function years:months

B

Brock

Looking for a function that will give me an answer in years and the remaining
months. Example

11/30/04 - 01/31/10 = 5 years and 2 months. the quistion is how do you get
the answer in years and months?


Thanks

Brock
 

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

help with Sum in between dates 12
Incone & Expenses Statement 0
If Function 1
Month days over a time period 5
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Modifying a complex date formual to count months 4
Linking Child Timelines to Multiple Parents 0
Extract Month and year from Cell containing date, month, year & time 2

Top