If the date goes into the next month leave it blank

[SDKBRK]

I have a formula and its simple cell + 1 gives me the next day.
example cell a1 date 1/31/17, formula in cell b1 +a1+1 gives me 2/1/17
I want a formula that will leave the cell blank if it goes to the next month.

Any help would be appreciated.

 

[JessyD]

Hello,

Try this:

=IF(MONTH(A1+1)<>MONTH(A1),"",A1+1)

 

[SDKBRK]

Thank you that work perfectly. I have not worked with date formulas. Thanks again.