What do I add to formula to only show current month?

[MHurtares]

I have a simple date formula: A1+1, A+2, A1+3, etc., where A1 is the first of the month. How do I stop this formula from displaying dates in the next month, since I am using 31 cells. In other words, if a date has less than 31 days, I would like a Blank result.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(ROWS(A$1:A2)>DAY(EOMONTH($A$1,0)),"",A1+1)

 

[MHurtares]

Hi & welcome to MrExcel.

The formula in each cell after A2 references the previous cell +1, not +2, +3, as previously stated.
Do I add the formula to each cell after A2?

 

[Fluff]

You should get rid of those merged cells, they are an abomination & should be avoided like the plague.