View Single Post
 
Old 04-04-2016, 12:30 PM
Exhale Exhale is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Mar 2016
Posts: 17
Exhale is on a distinguished road
Default Autofill dates - how can I get the same date and consecutive dates?

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.
Reply With Quote