Forum Discussion

Copper Contributor

Feb 28, 2017

Solved

Excel Date Autofill

Hi, Trying to autofill sequential dates in excel, despite altering how the series is filled, I still have the same results. Clicking and dragging increases the year rather than date: M...

excel

SergeiBaklan
Feb 28, 2017
That means in your cell under the Mon is the text, not date. To check you may click Ctrl+1 on this cell and format as the number. It shall show 42793 for February 27, 2017. Otherwise it'll be the text you entered.

You may do in opposite way - format this cell as number, insert 42793, after format as "dd/mm/yyyy". And after that fill the days.

If you are not sure what's you default date format take any empty cell, format is as Date (doesn't matter in which form), enter any number in this cell and check the formula bar - it shows the date in your default format.

benlewis75

Copper Contributor

Feb 28, 2017

Hi There, I see the smart tag, the options I have there are: copy cells / fill series / fill formatting only / fill without formatting None of these give the desired result. Thanks

SergeiBaklan
Diamond Contributor
Feb 28, 2017
Are your regional settings on UK date format?
- benlewis75
  Copper Contributor
  Feb 28, 2017
  Hi Sergei,
  
  Where do I find the option to change this?
  - SergeiBaklan
    Diamond Contributor
    Feb 28, 2017
    If not, enter first date in <your> date format (in my case ISO), press Ctrl+1 and enter in Custom format UK one for dates
    
    After that right click and drag the corner, press Fill Days
    
    Here they are