subject

Enter a formula in cell e4 to calculate how long each item has been on sale. this is calculated by subtracting the launch date in cell d4 from the data updated date in cell c20. to show the time in years, divide that result by 365. use an absolute reference to the date in cell c20. copy the formula from cell e4 to cells e5: e14.

in d4 is 3/17/2013
in c20 is 10/14/2016

any ? i have no idea what function is needed for this.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 20:40
Assume that there is a 4% rate of disk drive failure in a year. a. if all your computer data is stored on a hard disk drive with a copy stored on a second hard disk drive, what is the probability that during a year, you can avoid catastrophe with at least one working drive? b. if copies of all your computer data are stored on three independent hard disk drives, what is the probability that during a year, you can avoid catastrophe with at least one working drive?
Answers: 1
question
Computers and Technology, 23.06.2019 14:30
Select the correct answer. peter has launched a website that features baby products. however, clients often find they are unable to access the website because the server is down. which feature of cybersecurity should peter focus on for his website? a. data authenticity b. data privacy c. data availability d. data integrity e. data encryption
Answers: 3
question
Computers and Technology, 24.06.2019 21:40
Which of these is not a type of socket? aga (alternating grid array) pga (pin grid array) spga (staggered pin grid array) lga (land grid array)
Answers: 1
question
Computers and Technology, 25.06.2019 23:00
When viewing a document with hyperlinks in word, which key can be held on the keyboard in order to let the user click and visit the linked page or document when the cursor is on the hyperlink? escape control tab page up
Answers: 1
You know the right answer?
Enter a formula in cell e4 to calculate how long each item has been on sale. this is calculated by s...
Questions
question
Mathematics, 28.05.2020 02:09
Questions on the website: 13722361