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.