Home » Posts

Get last weekday in month

To get the last weekday in a month (i.e. the last Saturday, the last Friday, the last Monday, etc) you can use a formula based on the EOMONTH and WEEKDAY functions. In the example shown, the formula in D5 is: =EOMONTH(B5,0)+1-WEEKDAY(EOMONTH(B5,0)+1-C5)

April 14, 2025 · 1 min · 62 words · Eric Garza

For example, to get the last Thursday of a month, set dow to 5.

Note: I ran into this formula in ananswer on the MrExcel forum by Barry Houdini.

By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, but this is configurable.

Excel formula: Get last working day in month

it’s possible for you to use the WEEKDAY function inside other formulas to check the day of week.

Excel formula: Get nth day of week in month

Excel EOMONTH function

Excel WEEKDAY function