Question: Go to the Business Customer Analysis worksheet, which compiles data about the Texas business accounts that Kamal handles. Calculate the number of years a customer
Go to the Business Customer Analysis worksheet, which compiles data about the Texas business accounts that Kamal handles. Calculate the number of years a customer has been with Cello Worldwide as follows:
a In cell E enter a formula without using a function that subtracts the start date for the customer from the current date and divides the result by the number of days in a year, accounting for leap year.
b Use an absolute reference to cell C in the formula.
c Display the value in cell with one decimal place.
d Fill the range E:E with the formula in cell E
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
