How to autocomplete dates for every Monday, Wednesday, and Friday in 2025?
I found a previous post that had a formula for this for just Mondays but don’t know how to edit the formula to add Wednesdays and Fridays. Can someone help? Below is the formula I found, and I know I need to change 2024 to 2025
Is it also possible to have a cell between each week, or would I have to make that adjustment manually for each week?
=ARRAYFORMULA(FILTER(DATE(2024,1,1)+ROW(INDIRECT("A1:A366")),WEEKDAY(DATE(2024,1,1)+ROW(INDIRECT("A1:A366")))=2))