The Sequence Formula For Listing The First And Last Days Of The Month In Excel

Part 2 of the Excel Sequence Formula. Discover the Excel sequence formula for effortlessly generating a list of each month's first and last days. 🗓️💼
If you found this video useful or you want to see more like this, give it a like 👍
#ExcelTips #ProductivityHacks #ProgressCharts #DataVisualization #TrackYourSuccess

[JessicaJang]

like👍56
wow🤩
learned new formula👍
thank you always👍

[ginagarcia]

I need calculate due dates based on the last report date entered in a cell.

1. One year ahead, one month back, and that last day of the month.

2. Two months ahead and one day back.

[kmj]

I'm looking for how to do this using a date in a different cell as the start date. That date may or may not be the first day of a month.

[skylarporter]

Not sure if you can answer this quickly, but how to I start this sequence in the middle of the year. (i.e. What if I want to start it on October 1st and do every month from there on out?)

[AMathew]

Thanks . How can like. We need to know only Mondays and Thursday in month. And then how can we make it dynamic. That only Monday and Thursday are date allowed

[starfont]

Hi. In the example first day of each month, what if I wanted to start in, say, August?

[VL-xsbk]

Wow what a timesaver! Can this formula be done across columns vs down rows? Or do I need to do it down first then copy/paste formulas/transpose?

[angelicacarrillo]

Oh man I thought this would work for me, it doesn't. I'm trying to do consecutive months, with the same year BUT also the same date ie. 01/05/2023, 02/05/2023, 03/05/2023.