I would all the dates of the current month to be listed in a column, updated to the next month on the 1st of the month, and no requirement for me to input anything into the system. I've played around with multiple IF functions and different date formulas but can't get anything to work.
Asked
Active
Viewed 125 times
1 Answers
0
In your first cell, rebuild the first date of the month by forcing 1 as the date and reusing the year and month of the current date:
=DATE(YEAR(TODAY()), MONTH(TODAY()), 1)
In the next 30 cells, use and drag this:
=IFERROR(IF(MONTH(A1+1)=MONTH(A1),A1+1,""), "")
I'm sure there's a cleaner way but I can't be bothered.

ApplePie
- 8,814
- 5
- 39
- 60
-
Thanks. I used a variation of that as I discovered I wanted the date to change on the corresponding day of the month to the next month instead of the 1st. I used this formula =DATE(YEAR(TODAY()),MONTH(TODAY())+1,0) in cell A103 to get the last day of the month then used this one =IFERROR(IF(MONTH(A103-1)=MONTH(TODAY()),A103-1,DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(A103)-1)),"ERROR") to input the other days. Time will tell if this will work for all months or not – PhilosophizerMD Jan 01 '22 at 23:33