I have a date range that I have a formula to give me the number of days in between, however, for ease of looking, I would like the days to be converted into years/months/days.
For example, if the result is 2152 days - I would like to show it as 5 years, 10 months, 9 days (or whatever it actually is, lol)
I have my begining date in D2:D53, ending Date in E2:E53, and my =datedif(D2,E2,"d") in column F2:F53. The begining date would be counted as Day 1.
Can anyone assist?
Bookmarks