Question

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 help? I have no idea what function is needed for this.

Answer 1

DAYS(end_date, start_date)

where:

• end_date is the Updated date in C20 cell
• start_date is the Launch date in D4 cell