Answer:
The formula to enter in E14 is as follows:
=DAYS(D14,$E$10)
Explanation:
Required
Formula to calculate the number of days between E10 and D14
The syntax to do this is:
=DAYS(end_date,start_date)
So, we have:
=DAYS(D14,E10)
The question requires a mix of relative and mixed references because cell E10 will be constant in calculating the difference for dates in other cells.
In other words, the initial date is constant for all
So, the update formula is:
=DAYS(D14,$E$10)
Notice the $ between in E10; this represents mixed referencing
When dragged to E15 till E68, the formulas in the respective cells will be:
=DAYS(D15,$E$10) .............................. =DAYS(D68,$E$10)
