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

In Excel: 11/4/2026, Estimated issue becomes Estimated issue 11/04/2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8="", … absent"Asks for review when the date is missing.Not used for row 8
2IF(B8="Actual issue", … )Writes Issued and the date for an actual date.Not used for row 8
3IF(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
5IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own list. Paste each payment date and its checked basis into the green columns of the Template tab.
  3. 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