333,154 views
9 votes
9 votes
In cell E14, enter a date function that calculates the number of days between the Initial Deadline (cell E10) and the Date Received for the first student (D14). Use mixed and relative references appropriately. Copy the function to the range E15:E68. A negative value indicates the application was received after the initial deadline.

User Tehleel Mir
by
3.0k points

1 Answer

27 votes
27 votes

Answer:

The formula to enter in E14 is as follows:

=DAYS(D14,$E$10)

Step-by-step 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)

User Steven Johnston
by
2.5k points