Feb 22 2023 06:16 AM
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
Feb 22 2023 06:20 AM
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
Feb 22 2023 06:25 AM
Feb 22 2023 06:36 AM
What is the formula you have tried to use?
Feb 22 2023 06:45 AM
I used =D4-C20/365
Tried the "IF" function and "EDATE" and pretty much the same result
Feb 22 2023 06:59 AM
Since division goes before subtraction, your formula will divide C20 by 365 and subtract the result from D4.
To divide the difference D4-C20 by 365, you must use parentheses.
And please follow the link to the article about absolute references - it'll tell you how to make C20 absolute.
Feb 22 2023 07:02 AM