Use a revised date only when approved

Keep the original completion date unless the extension is marked TRUE.

What you'll make

In Excel: 11/4/2026 + 12/4/2026 + TRUE becomes December 4, 2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1NOT(ISLOGICAL(C8))Checks that column C isn't TRUE or FALSE.FALSE
2IF(B8="", … ,B8)Approved: uses the revised date, or asks for one.December 4, 2026
3IF(B8<>"", … ,A8)Not approved: keeps the original, or flags a change.Not used for row 8
4IF(C8, … )Uses part 2 when approved, part 3 when not.December 4, 2026
5IF( … )Shows the flag message when part 1 is TRUE.December 4, 2026

Works from the inside out. Column C must hold TRUE or FALSE, not yes or no.

=IF(NOT(ISLOGICAL(C8)),"Review extension approval flag",IF(C8,IF(B8="","Review approved extension without date",B8),IF(B8<>"","Review unapproved completion change",A8)))

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 the original completion date, any revised date, and TRUE or FALSE into the green columns of the Template tab. The completion dates fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Mark TRUE only for an approved extension. The formula doesn't decide whether one is allowed.

Microsoft's help: IS functions