Sheets AcademySheets Academy
Premium
Task #22

Contract status

A lawyer keeps track of contract deadlines. Today's date is in F1.

In C2:C9, show the contract status:

  • "Expired" if the end date has already passed;
  • "Soon" if there are 30 days or fewer until the end date;
  • "Active" in all other cases.

Compare the end dates with the date in F1, not with the TODAY function: with it, the statuses would change every day, and the answer couldn't be checked.

Task #22
Contract status

A lawyer keeps track of contract deadlines. Today's date is in F1.

In C2:C9, show the contract status:

  • "Expired" if the end date has already passed;
  • "Soon" if there are 30 days or fewer until the end date;
  • "Active" in all other cases.

Compare the end dates with the date in F1, not with the TODAY function: with it, the statuses would change every day, and the answer couldn't be checked.