Time formatiing

[Terry Bennett]

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?

 

[Peo Sjoblom]

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]

Looks good! Many thanks.

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)