Build an Excel Formula to List All Mondays of the Month, Based on one Date.

In this video you learn how to build a dynamic-array Excel formula that automatically lists all dates that fall on a specific weekday for an entire month. We take advantage of SEQUENCE, EOMONTH, DAY, DATE, YEAR, MONTH and FILTER functions.

[@annasullivan7984]

Amazing, thank you so much Igor. Exactly what I needed and very well explained.

[@sebastianschick1989]

perfect - you've made my day 👌👌😎😎

[@Wellard123]

Igor - Awesome thank you - No more static data in Hidden Columns

[@Epic_Lana]

So many useful tips! I have been =CONCAT like a fool &&&&&

[@mountainbiker9330]

Thanks for this.

[@DebSchwichtenberg-c7r]

Is there a way to do this in google sheets? Hastag doesn't work in Google Sheets unfortunately.

[@softigor]

Yes, google sheets does not have dynamic arrays. There are workarounds using functions like ARRAYFORMULA, COUNTA, FILTER, INDIRECT, etc.