True, except that that will give you 27 days, and not the 24 that the Op
wants ;-)
--
Hth

Kassie Kasselman


"Max" wrote:

Another play ..

With source numbers in A1 down.

Put in say, B1:
=IF(A1="","",TEXT(A1,"y")&" years, "&TEXT(A1,"m")&" months and
"&TEXT(A1,"d")&" days")
Copy B1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"K. Krishna Murthi" wrote:
I want to convert a number and display it as Number of Years, Months and
Days. eg
8548 converts into 23 Years, 4months and 24 days.