Write a service date or service period

Turn a start and end date into 11/04/2026 through 12/04/2026, or write one service date.

What you'll make

In Excel: 11/4/2026 to 12/4/2026 becomes 11/04/2026 through 12/04/2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8<>""Checks for a single service date.No
2OR(B8<>"",C8<>""),"Review both…"Flags a row with both a date and a period.Not used for row 8
3TEXT(A8,"mm/dd/yyyy")Writes the single date.Not used for row 8
4TEXT(B8,…)&" through "&TEXT(C8,…)Writes the start through the end."11/04/2026 through…"
5IF( … )Picks the date, the period or a message."11/04/2026 through…"

Read it left to right. Before part 4, two checks catch a row with no dates or half a period.

=IF(A8<>"",IF(OR(B8<>"",C8<>""),"Review both date and period",TEXT(A8,"mm/dd/yyyy")),IF(AND(B8="",C8=""),"Service context not supplied",IF(OR(B8="",C8=""),"Review partial service period",TEXT(B8,"mm/dd/yyyy")&" through "&TEXT(C8,"mm/dd/yyyy"))))

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 dates. Paste one service date, or a period start and end, 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

Use the dates the source gives for the service. Don't fill a gap with the date the response was made.

Microsoft's help: TEXT function