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 Tuesday October 2024
2=EOMONTH(A1, -1) +1+CHOOSE(WEEKDAY(EOMONTH(A1, -1)+1, 2), 0, 0, 0, 0, 0, 2, 1) = 01 Tuesday October 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


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top