If formula based on month

[rjwebgraphix]

Cell A4 is the 1st day of the month entered as 6/1/11, but formatted as mmmm. So it displays only the months name.

Cell B4 is just =A4, but only formatted as d.

Subsequent B cells B5, B6, B7 and so on are just =B4+1, =B5+1, =B6+1 and so on for 31 cells down.

These dates are used when calculating data that populates the rest of the spreadsheet in a macro, so have to stay as dates even though it looks like 1,2,3,4 etc.

I'm trying to weed out anything that would go on to the next month. So I'll need an if statement that says, If month has less than 31 days, and this date would go to the next month, then just display "-".

I hope that makes sense. I have a larger purpose for the formula in another column, but if I can understand this part, the other should be easy.

Thanks,

RJ

 

[rjwebgraphix]

This is the part I'm having trouble with....

=IF(B32 is not the month in cell B4, "-", "=B31+1")

 

[Marcelo Branco]

Hi,

Maybe this

Formula in B5
=IF(MONTH(B4+1)<>MONTH($A$4),"-",B4+1)
copy down

HTH

M.