I hope that this is a simple one for someone to answer!



If I highlight a cell with a date in it and get the black cross in the right hand lower corner, I can extend a series of dates (I'm using the UK system of day - month - year) and it will add a day on for me in each of the next cells. If I needed to have the same date in a few of the next cells and then pick up the date addition again, how can I do this other than by typing manually, each date, please?

I have Windows 10 and Excel version 14.0.7166.5000 (32 bit).

Thanks in anticipation.