Date Calculations
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. |
Hi Derek,
See http://www.cpearson.com/excel/datedif.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "mulhod" wrote in message ... 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. |
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") -- Anisa "mulhod" wrote: 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. |
Exactly what I was looking for. Many thanks.
"Niek Otten" wrote: Hi Derek, See http://www.cpearson.com/excel/datedif.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "mulhod" wrote in message ... 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. |
All times are GMT +1. The time now is 08:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com