79712263

Date: 2025-07-23 16:18:12
Score: 1.5
Natty:
Report link

I think this AI-assisted answer is the clearest:

=EOMONTH(A1,0)-MOD(WEEKDAY(EOMONTH(A1,0),2)-5,7)

A1 is a date value with any date in the subject month

-5 is for Friday. For other days:
-4 is for Thursday
etc for the sequence -1 (Monday) through -7 (Sunday)

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: Larry