These formulas will give you the whole number of days, months, and years.

=DATEDIF(A1,B1,"MD")
=DATEDIF(A1,B1,"YM")
=DATEDIF(A1,B1,"Y")

Why would you want fractions? How much of a month is 1 day; 1/31 of a
month, or 1/30? If you really wanted to estimate the fraction portion you
could try these instead

=B1-A1
=(B1-A1)/30
=(B1-A1)/365

"Ruby" wrote:

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