Question

D4=3/17/2013 C20=10/14/2016

11. 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.11. 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.

Answer 1

Dear student,

The above problem can be solved using DATEDIF() function in excel.

I have used two ways to get number of years between 2 dates. the second one is optional for you.

1.  =(DATEDIF(D4,C20,"D"))/365 this returns number of days between 2 dates and then i further divide number of days with 365.

2.  =DATEDIF(D4,C20,"Y") this returns years with out decimal

Screenshot of excel sheet

If you have any doubt please comment below also don't forget to hit the thumbs up button.

thank you :)