Thread: How do I convert a number into Years, Months, Days format?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
K. Krishna Murthi K. Krishna Murthi is offline
external usenet poster
  
Posts: 1
Default How do I convert a number into Years, Months, Days format?
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.
Reply With QuoteReply With Quote