Posted to microsoft.public.excel.worksheet.functions
|
|
Time formatiing
Looks good! Many thanks.
"Peo Sjoblom" wrote in message
...
Assuming here
=DATEDIF(A1,TODAY(),"y")&" Year(s), "&DATEDIF(A1,TODAY(),"ym")&" Month(s)
and "&DATEDIF(A1,TODAY(),"md")&" Day(s)"
for info on DATEDIF see:
http://www.cpearson.com/excel/datedif.htm
--
Regards,
Peo Sjoblom
(No private emails please)
"Terry Bennett" wrote in message
...
I need to express a period of time in terms of years, months and days.
The formula will be something like: TODAY()-A1
Obviously, I can divide by 365.26 to get the number of years but how can
I convert the decimal element into months/days?
|