Days to yrs/mnths/days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that calculates senority. So Start date to Now() gives me a day
rating say 3011 days. How would I extend the below code so the ranking reads
yrs/mnths/days?? Any help would be greatly appreciated!

Here is the code I am using to get it to days;
=DateDiff("d",[Hire Date],Now())

Thanks
 
Back
Top