Add the previous date +1 day to desired cell

[lukerees83]

I am collating some data from 2010, so in cell A1 I have the date 01/01/2010.

I am then pasting in some data from this day, in the first instance there is 11 rows of it. I'm then moving onto 02/01/2010 and so on. The date will always be marked in column A.

I would like a formula that says "please take the last date you see in column A and add 1 day to it".

Alternatively a formula that says "after cell A1 leave x rows blank then put A1's date plus a day and do this every x rows, adding a day each time, but stopping once you get to the end of the month."

 

[AlphaFrog]

You could do this with the Autofill Handle.

• Put a Date in cell A1
• Select cells A1:A11
• Grab the Fill Handle (the small black square in the lower right of the selection outline)
• Drag down 330 rows

 

[lukerees83]

Brilliant!

Many thanks.