At Westonci.ca, we provide reliable answers to your questions from a community of experts. Start exploring today! Discover comprehensive answers to your questions from knowledgeable professionals on our user-friendly platform. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

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.


Sagot :

Answer:

[tex]\boxed{\frac{(C2-E5)}{365.25}}[/tex]

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: [tex]= \frac{(C2-E5)}{365.25}[/tex]. Hover over C2 and tap F4. This renders the entire source.

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