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?

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?

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?