View Single Post
  #1   Report Post  
because
 
Posts: n/a
Default how do I convert a number to number of years, months and days

In cell a1 I have a number that represents hours worked by an employee. I
need a formula that converts that number into years, months and days.All I
can do is come up with a formula that brings up the result 8.5 years