Pick the work, apply or request date

Pick the date a timecard row asks for: work, correction apply or request.

What you'll make

In Excel: Apply: work 11/4/2026, apply 11/12/2026 becomes 11/12/2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1SWITCH(A8,"Work",IF(B8="","",B8),…)Takes the date for the basis in column A.11/12/2026
2IF(v="","Review missing selected date",v)Flags the row if that date is empty.11/12/2026
3LET( … )Names part 1's answer v so part 2 can check it.11/12/2026

Part 1 gives Review date basis for any other basis word.

=LET(v,SWITCH(A8,"Work",IF(B8="","",B8),"Apply",IF(C8="","",C8),"Request",IF(D8="","",D8),"Review date basis"),IF(v="","Review missing selected date",v))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own list. Paste each row's basis and its work, apply and request dates into the green columns of the Template tab. The selected date fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Choose the basis your report needs. A correction applied this week can be for work in an earlier pay period.

Microsoft's help: SWITCH function