Auto fill dates

I want to auto fill dates while leaving blanks where needed see AutoFill Dates.xlsx

Originally Posted by slasherdan

try this
[B=IF(W10>=31,"",W10+1)[/B]
It basically says that if the cell is greater or equal to 31 then make this cell blank if not add 1 day to the value of the previous cell

you can leave the > out, since the values already jump to 1 after a value of exactly 31 is found

plus this does result in one blank cell and the one after that becomes 1 again...
so a little modification:
=IF(OR(W10="",W10=31),"",W10+1)

Edit: if you manually fill the first number, use the formula after that and pull through. but first replace W10 with the cell with the manually entered number.
so if you would put 2 in B10, then use the formula in C10 (while replacing W10 with B10) and drag the formula all the way to Z10

Take a look at this

Hiding days after 31 only works for half the months. You actually want to stop showing dates after the last day of the month, whatever month it is. Sometimes that's 31, sometimes 30, sometimes 28, sometimes 29. I assume you also want the numbering to start on the correct day.

When dealing with dates in Excel it is always better to use actual dates instead of typing in month names and using integers. I have changed your month names to actual dates, and the numbers that appear in your tables are the day-of-month numbers of dates. Enter the month by typing the date for the first day of the month (e.g., 8/1/2013 will display as August).

Once you enter the date of the first of the month, all the rest of the numbering is fully automatic. I had to add a row of numbers in row 1 to indicate the day number for each column. There are other ways to do this but this is the most straightforward and robust against changes to data layout.

See attachment, let me know if this is what you are looking for.