Function to calculate the number of years, months and days between

G

Guest

Hi,
Hope you can help. I am trying to find a Function to calculate the number
of years, months and days between 2 dates. Such as to calculate how old
someone is down to the day.

I have played with the YEARFRAC fx and the following:
=(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)

I know I am missing something. Can you help?

Thanks so much!
 

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

Calculating Months while taking into consideration days 3
Calculate number of days 6
Excel - Calculate age from DOB in years, months days 7
count months between years 3
How to calculate "number of months" between two given date? 23
Number of years, months, days between two dates. 34
problem of converting days months and years 3
calculating years/months with YEARFRAC? 4

Top