Date Calculations

G

Guest

I am familiar with the YEARFRAC function to calculate the period between two
dates. Rather than display the answer as a decimal, I require to show Years,
Months and Days. Can anyone advise how I might do this?

Many thanks

Derek.
 
G

Guest

A B C

First Date Second Date
1 Date 10-Dec-1970 20-Jul-2005
2 Years 34
3 Months 7
4 Day's 10

In Cell B3 put the formula =DATEDIF($B$2,$C$2,"Y")

In Cell B4 put the formula =DATEDIF($B$2,$C$2,"YM")

In Cell B5 put the formula =DATEDIF($B$2,$C$2,"MD")
 

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 age from date of birth and ignoring if blank 5
yearfrac 2
calculating years/months with YEARFRAC? 4
edate and yearfrac functions not tallying 1
Function to calculate the number of years, months and days between 2
yearfrac format error? 4
Excel - Calculate age from DOB in years, months days 7
Calculating Dates in Terms of Months 4

Top