Hello, I have been reading a lot of the Q&A here, but I haven't found one
that worked perfectly for my spreadsheet. I even went to the Pearson site,
but I didn't have any luck with the formulas.

GOAL: Multi-function cell
Calculate the number of days, months, and years, then have each result
displayed as a specific number (rounded to the nearest fraction, preferably
to the 100th or even as a quarter fraction).

Can anyone provide the exact formula for me to use?

Please use the following cells:
A1 = Date Submitted
B1 = Date Approved
C1 = Length of Time: Days
D1 = Length of Time: Months
E1 = Length of Time: Years

Thank you very much!
--
Ruby