Forum Discussion

benlewis75's avatar
benlewis75
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's avatar
    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.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 22, 2017

Hi Des,

 

In Excel 2016 Pro it's also no problem with that if your dates are in correct format and proper options are selected for Fill->Series (i.e.Series In = Rows)

 

Des Machin's avatar
Des Machin
Copper Contributor
Aug 25, 2017

Hi Sergei Thanks for your reply. I have followed that procedure but it didn't work - I received the error message thats attached as a screen print. Please help. I have checked and all of the cells are merged and are clearly the same size.

 

Resources