Sheets AcademySheets Academy
Premium
Task #41

Due date and days late

An invoice must be paid within 14 days after it is issued.

  1. In C2:C7, calculate the payment due date.
  2. In E2:E7, calculate how many days late the customer paid. If they paid on time, show 0.
Task #41
Due date and days late

An invoice must be paid within 14 days after it is issued.

  1. In C2:C7, calculate the payment due date.
  2. In E2:E7, calculate how many days late the customer paid. If they paid on time, show 0.