Date difference
Calculate the number of days between two invoice dates by subtraction, add days to a date, and count full weeks with INT — 6 guided steps.
Compute the difference between D2 and C2 in G2
1 / 6
Compute the payment period of INV-001 (D2 − C2)
=D2-C2
Compute the difference between D5 and C5 in G2
2 / 6
Compute the payment period of INV-004 (D5 − C5)
=D5-C5
Compute the difference between D10 and C10 in G2
3 / 6
Compute the payment period of INV-009 (D10 − C10)
=D10-C10
Compute the difference between C6 and C2 in G2
4 / 6
Number of days between the issue of INV-001 and INV-005 (C6 − C2)
=C6-C2
Add 7 days to C2 in G2
5 / 6
Add 7 days to the issue date of INV-001 (C2)
=C2+7
Divide the difference D4−C2 by 7 and round down with INT — G2
6 / 6
Number of full weeks between C2 and D4 (use INT)
=INT((D4-C2)/7)
Your score is
Restart
