How To Auto Fill The Dates

Good afternoon,

How can I get the dates in Columns A and C to auto fill? I know how to do it when they do not have spaces between each line, (meaning I would input one date and then double click that bottom right corner of the cell for the rest to autofill) but I am struggling to figure out how to get it to work with spaces in-between. I am also struggling to figure out how to explain it, so of course I am attaching an example. Thank y'all in advance.

I don't know if there's a reason there's no Sept 2nd in your file, but perhaps you could use this approach. After entering the first date in A3, add the below formula in A4 and copy down.

Formula:

Please Login or Register  to view this content.

If there's a blank cell in column H on the previous row the formula will add one to the highest date above the current cell in column A and put that in the cell. If not it will leave it blank.

BSB

Thank you so much! This worked for me!! The not including Sep 2nd was human error lol which I am trying to avoid at all costs in this sheet (:

Happy to help

BSB