Why date calculations drive business logic in Google Sheets - Formula Trace Breakdown

Sample Data

This data shows start and end dates for tasks or projects. We want to calculate how many days each task took by subtracting the start date from the end date.

Cell	Value
A1	Start Date
B1	End Date
C1	Days Difference
A2	2024-06-01
B2	2024-06-10
A3	2024-06-15
B3	2024-06-20
A4	2024-06-25
B4	2024-07-05

Formula Trace

=B2 - A2

Step 1: B2 - A2

Step 2: 44968 - 44959

Cell Reference Map

    A         B         C
1 |Start Date|End Date |Days Diff|
2 |2024-06-01|2024-06-10|  =B2-A2 |
3 |2024-06-15|2024-06-20|         |
4 |2024-06-25|2024-07-05|         |

The formula in C2 subtracts the start date in A2 from the end date in B2 to find the days difference.

Result

    A         B         C
1 |Start Date|End Date |Days Diff|
2 |2024-06-01|2024-06-10|    9   |
3 |2024-06-15|2024-06-20|         |
4 |2024-06-25|2024-07-05|         |

The result in C2 shows 9, meaning the task took 9 days from start to end.

Sheet Trace Quiz - 3 Questions

What does the formula =B2 - A2 calculate?

A The number of days between the start and end dates

B The sum of the start and end dates

C The difference in months between the dates

D The time of day difference

Key Result

Subtracting one date from another returns the number of days between those dates.