Auditing & Error-Proofing: Flag Large Weekend Postings

Excel Formulas › Auditing & Error-Proofing

All versions

Entries posted on a weekend are not wrong, but large ones are a classic internal-control check because normal staff rarely work weekends. WEEKDAY with return type 2 numbers Monday as 1 and Sunday as 7, so anything above 5 is a weekend. Combining it with an amount threshold keeps the review list short.

Quick formula: Weekend (WEEKDAY above 5) and amount at or above the threshold returns Review:

=TEXT(B2,"ddd")

A $2,400 entry posted Saturday 10/24/2026 is flagged; the same amount on Thursday is OK.

Functions used (tap for the full reference guide):

IF AND WEEKDAY TEXT

The example

Three postings. Only the large weekend entry is flagged.

	A	B	C	D	E
1	Case	Posted date	Amount	Day	Flag
2	Entry 1	Sat 10/24/2026	$2,400	Sat	Review
3	Entry 2	Thu 10/22/2026	$2,400	Thu	OK
4	Entry 3	Sun 10/25/2026	$450	Sun	OK

The formula

Two conditions must both be true:

=TEXT(B2,"ddd") // day name; flag = IF(AND(WEEKDAY(Date,2)>5,Amount>=1000),"Review","OK")

How it works

Here is the logic, one piece at a time:

TEXT(B2,"ddd") shows the day name for context.
WEEKDAY(B2,2)>5 is true for Saturday and Sunday.
C2>=1000 is the amount threshold.
AND requires both; IF turns the result into a label.

Keep the threshold in a cell so the auditor can change it without editing formulas.

Try it: interactive demo

Interactive

Enter a posting date and amount.

Posting date (YYYY-MM-DD)

Amount ($)

Variations

Threshold in a cell

Reference a named cell for the dollar limit.

=IF(AND(WEEKDAY(B2,2)>5,C2>=$H$1),"Review","OK")

Count flagged entries

Count entries marked Review.

=COUNTIF(E2:E500,"Review")

Pitfalls & errors

Use WEEKDAY(date,2). The default return type treats Sunday as 1 and Saturday as 7, which breaks a simple >5 test.

Dates stored as text fail. Convert them first or the formula returns an error.

Add holidays to the logic with a holiday list and COUNTIF if you also want to flag those.

Practice workbook

📊

Download the free Auditing & Error-Proofing: Flag Large Weekend Postings practice workbook

Edit the yellow date and amount cells; day name and flag recalculate.

Frequently asked questions

Why flag weekends at all?

Weekend entries often fall outside normal processing and are a quick screen for unusual activity.

Can I combine with approvals?

Yes. Add another AND condition for missing approver.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: IF AND WEEKDAY TEXT