Thread: How do I convert a number into Years, Months, Days format?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How do I convert a number into Years, Months, Days format?
Agreed <g.

8548 returns: 23 years, 5 months and 27 days

It was just an "approx." thought thrown in here.
I didn't want to get involved in the intricasies.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"kassie" (Change all to lowercase) wrote in
message ...
True, except that that will give you 27 days, and not the 24 that the Op
wants ;-)
--
Hth

Kassie Kasselman


Reply With QuoteReply With Quote