Question

In cell E5, enter a formula without using a function that subtracts the start date for
the customer from the current date and divides the result by 365.25, the number
of days in a year, accounting for leap year.

Answer 1

Answer:

$\boxed{\frac{(C2-E5)}{365.25}}$

Explanation:

First, tap on cell E5. Add: = .

Next, tap cell C2. The current date of 11/02/2021, doing this, you would be presented: =C2 . Add: -. Then tap on D5.

The equation in E5: =C2-E5. It should be: $= \frac{(C2-E5)}{365.25}$. Hover over C2 and tap F4. This renders the entire source.

Lastly, illustrate the input in cell E5 with one decimal place.