Thread: Time formatiing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terry Bennett
 
Posts: n/a
Default Time formatiing

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?