Forum Discussion
Need to subtract dates then divide the answer by 365
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 y...
That looks like a homework assignment. You will learn much more if you try to solve this yourself.
The instructions are pretty clear: in E3, enter a formula that subtracts D4 from C20 and divides the result by 365.
The reference to C20 should be absolute - see Absolute Reference
- My bad, I am stuck because of something I'm not doing correctly. When I do as I am understanding, I get a much larger number, and when attempting to copy all columns equal the same. That is not correct, in looking at the answer sheet the numbers are much lower and different
What is the formula you have tried to use?
