← All exercises

TODAY — Invoice due dates

TODAY & due dates

Use TODAY() to flag overdue and upcoming invoices from their due date — 6 guided steps on a 10-invoice table.

Write the TODAY() function in G2

1 / 6

Display today's date with TODAY()

Calculate D2 minus today's date in G2

2 / 6

Calculate the days remaining before the due date (D2 − today)

Calculate D6 minus today's date in G2

3 / 6

Days remaining for FAC-005 (D6 − today)

Write an IF comparing D2 to TODAY() in G2

4 / 6

IF invoice FAC-001 is overdue, display "Overdue", otherwise "OK"

Write an IF comparing D7 to TODAY() in G2

5 / 6

IF invoice FAC-006 is overdue, display "Overdue", otherwise "OK"

Compare D6−TODAY() to 30 in an IF — cell G2

6 / 6

IF the FAC-005 due date is less than 30 days away, display "URGENT", otherwise "OK"

Your score is

0%