Formula not blanking dates after month end

[Ochimus]

Attached sample has a formula "dragged" across row 3:

IF(C3+1=">"&EOMONTH($B$1,0),"",C3+1)

If adding a day to the date in C3 takes it past the last day of the month in B1, cell to be blank. Otherwise add a day to the C3 date.

As shown on the attached, however, it isn't working. L3 and M3 should be blank, but are showing the 1st and 2nd of May.

Any ideas, pointers or solutions welcomed as ever.

Ochimus

[MarvinP]

Hi Ochimus,

Try this in L3 and pull right

Please Login or Register  to view this content.

[protonLeah]

B3:

Please Login or Register  to view this content.

[JohnTopley]

The construct in your formula is wrong ..

IF(K3+1=">"&EOMONTH($B$1,0),"",K3+1)

should be

IF(K3+1>EOMONTH($B$1,0),"",K3+1)

Marvin's addition of the IFERROR resolves the problem that would occur in M3 when you try to add to L3 which is blank (null).

[Phuocam]

Or try this in C3:

=IF(B3="","",IF(B3+1>EOMONTH($B$1,0),"",B3+1))

[Ochimus]

First, apologies to each of you who took the time to reply. Should have acknowledged your help before now. Just that sometimes RL gets in the way!

Having found the answer with your help, can now mark this as "solved"

Ochimus