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 Thursday December 2022
2=EOMONTH(A1,-1)+1+CHOOSE(WEEKDAY(EOMONTH(A1,-1)+1,2),0,0,0,0,0,2,1) = 01 Thursday December 2022

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


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