Label estimated or actual issue dates
An estimated issue date isn't a cleared payment. Say which kind each date is.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8="", … absent" | Asks for review when the date is missing. | Not used for row 8 |
| 2 | IF(B8="Actual issue", … ) | Writes Issued and the date for an actual date. | Not used for row 8 |
| 3 | IF(B8="Estimated issue", … ) | Writes Estimated issue and the date. | "Estimated issue 11/04/2026" |
| 4 | "Review: … unverified" | Asks for review when the basis is any other word. | Not used for row 8 |
| 5 | IF( … ) | Checks the date first, then each basis in turn. | "Estimated issue 11/04/2026" |
Read it left to right. The basis must be Estimated issue or Actual issue, in any capitals.
=IF(A8="","Review: payment issue date absent",IF(B8="Actual issue","Issued "&TEXT(A8,"mm/dd/yyyy"),IF(B8="Estimated issue","Estimated issue "&TEXT(A8,"mm/dd/yyyy"),"Review: issue date basis unverified")))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 payment date and its checked basis into the green columns of the Template tab.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
An issue date doesn't show the money arrived or cleared. Check the deposit before saying it's paid.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Label the maximum you may be billed
48.60 → Source maximum you may be billed: 48.60
Get the template →
Write a claim item-detail-subdetail path
C101 + 1 + 2 + 1 → C101 | item=1 | detail=2 | subdetail=1
Get the template →
Label a payment adjustment
-25.00 + Recovery → Payment-level adjustment: -25.00; Recovery
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →