Auto-filling dates but leaving blank if nothing entered

Hello,

I'm trying to let users enter the month (by number) and have the spreadsheet auto-fill dates in cells A9 and below. I want it to be appropriate to the month (for example, February only has 28 days). I've got it working with the following, but it returns a '#VALUE!' error in cells A10 and below when nothing is entered in B6. Is there any way to adjust this so that nothing displays in A10 and below when nothing is entered in B6? Any suggestions would be greatly appreciated!

B6 is the number of the month that is to be entered.
A9=IF(B6=0,"",DATE(YEAR(NOW()),B6,1))
A10=IF(DAY(IF(A9="",0,A9)+1)>DAY(A$9),A9+1,"")

The way I do it is with conditional formatting. Set the conditional format to 'Formula Is' and then put

Please Login or Register  to view this content.

Then set the format to have white text on a white background when the required cell is showing an error.

In the print options you set it to not print out errors too.

Hope this helps