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: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 18:40
Mariah was working on a multimedia presentation that included both video and audio files. the file was huge, and she wanted to send it to her coworker in another office. she needed to reduce the size of the file so that it could be transmitted faster. the utility she used to do this was
Answers: 2
question
Computers and Technology, 24.06.2019 12:00
What is a sketch or blueprint of a web page that shows the structure (but not the detailed design) of basic page elements such as the logo, navigation, content, and footer?
Answers: 3
question
Computers and Technology, 24.06.2019 13:00
Why should you evaluate trends when thinking about a career path?
Answers: 1
question
Computers and Technology, 24.06.2019 13:20
In the insert table dialog box, you select the checkbox to create the first row as the header of the table.
Answers: 3
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
Spanish, 05.07.2019 00:30
Questions on the website: 13722359