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,"")