Return the first weekday of the month

You can return the first weekday of the month
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

	A
1	=TODAY() = 01 Monday April 2024
2	=EOMONTH(A1, -1) +1+CHOOSE(WEEKDAY(EOMONTH(A1, -1)+1, 2), 0, 0, 0, 0, 0, 2, 1) = 01 Monday April 2024

1 - Displays a date.

Built-in Functions

CHOOSE - The value in a row (or column) based on an index number.
EOMONTH - The date serial number of the last day of a month before or after a date.
TODAY - The date serial number representing today's date.
WEEKDAY - The day of the week for a given date.

Related Formulas

Return the first weekday of the year
Return the last weekday of the month
Return the last weekday of the year