Answered

Looking for trustworthy answers? Westonci.ca is the ultimate Q&A platform where experts share their knowledge on various topics. Join our platform to connect with experts ready to provide precise answers to your questions in various areas. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.

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.

Thank you for your visit. We are dedicated to helping you find the information you need, whenever you need it. We hope our answers were useful. Return anytime for more information and answers to any other questions you have. Thank you for using Westonci.ca. Come back for more in-depth answers to all your queries.