# Need to subtract dates then divide the answer by 365

Occasional Contributor

# 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 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

7 Replies

# Re: Need to subtract dates then divide the answer by 365

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

# Re: Need to subtract dates then divide the answer by 365

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

# Re: Need to subtract dates then divide the answer by 365

What is the formula you have tried to use?

=D4-C20/365

# Re: Need to subtract dates then divide the answer by 365

I used =D4-C20/365

Tried the "IF" function and "EDATE" and pretty much the same result

# Re: Need to subtract dates then divide the answer by 365

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.