Hide Wrong Date #2

[AlanWade]

In my previous post: http://www.mrexcel.com/forum/showthread.php?p=2828311#post2828311

You's were kind enough to show me how to hide the date. This has thrown up a second problem of the last three days effectively 29th, 30th and 31st had this formula: =IF(MONTH(A33+1)>MONTH(A33);"";A33+1) to hide the date if the month didnt have 31 days in it. How can I include this =IF(A2="";"";A2+1) into the formula so that if there is date entered these cells wont show an error as the previous cells, but if the month is Feb for example it wont display 29th, 30th or 31st.

Thanks Again
Alan

 

[AlanWade]

Can anyone help with this problem?

 

[VoG]

Perhaps

=IF(A33="";"";IF(MONTH(A33+1)>MONTH(A33);"";A33+1))

 

[AlanWade]

Once again, thankyou very much for your help.

Alan