Date & Time functions
FIRST.MONDAY
About
Returns the first Monday of the month.
Code
M.S. Excel
FIRST.MONDAY = LAMBDA(anydate,
LET(
start_of_month, DATE(YEAR(anydate), MONTH(anydate), 1),
CHOOSE(WEEKDAY(start_of_month), 1, 0, 6, 5, 4, 3, 2) + start_of_month
)
);
Feedback
Submit and view feedback