Pick the work, apply or request date
Pick the date a timecard row asks for: work, correction apply or request.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | SWITCH(A8,"Work",IF(B8="","",B8),…) | Takes the date for the basis in column A. | 11/12/2026 |
| 2 | IF(v="","Review missing selected date",v) | Flags the row if that date is empty. | 11/12/2026 |
| 3 | LET( … ) | 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.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- 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.
- 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
OTHER ROUTES YOU MIGHT LIKE

Turn workdays into paid hours
1.5 workdays at 8 paid hours → 12 hours
Get the template →
Get decimal hours by measure type
0.5 elapsed days → 12 hours
Get the template →
Prevent a repeated meal deduction
8.5 hours, 0.5 meal, deduction requested → 8 hours
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →