Excel Magic Trick 1123: Dynamic Formula To Create A List of Dates For Month

See how to create a formula To Create A List of Dates For Month. Change the start date and the list updates. See the functions, EOMONTH, DAY, IF, ROWS.

[alirachini]

Even after 9 years sir, you are still a chad !

[excelisfun]

Excel Magic Trick 1123: Dynamic Formula To Create A List of Dates For Month
See how to create a formula To Create A List of Dates For Month. Change the start date and the list updates. See the functions, EOMONTH, DAY, IF, ROWS.

[excelisfun]

@Excel Fan Yes, you got it: each video builds up to 1126! Your formula is great!

[excelfan]

So happy new videos thought i had to wait till July for Power Pivot : ). love any video that gets the thinking cap on. I have watched them all and each one builds on what we have learned in the last nice way to present it, it felt like we were building up to the mini project in 1126.

here's my take on 1123:
=IF(ROWS($A$5:A5)>$B$2, "", (EOMONTH($B$1, -1)+1)+ROWS($A$5:A5)-1)

If i have learned anything from ExcelIsFun there are lots of ways to have fun in excel

thank you as always

[chilloutall]

Hi
I am creating a holiday planner and is stuck with some formulas, Help Or explanations will be very good.

I am struggling with adding weekdays and weekends to my formulas so far. I also want it to add a day to the calender if I worked that day, and subtract a 0.5 day if i have only worked a 0.5 day

Thanks

[krn]

Thanks Mike.  How's Power Pivot coming along?  

[chowman]

Mike, how can you modify your formula to only show the first half of the month or the later part as in pay periods?