Forum Discussion
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:
| MON | TUE | WED | THU | FRI | SAT | SUN |
| 27/2/2017 | 27/2/2018 | 27/2/2019 | 27/2/2020 | 27/2/2021 | 27/2/2022 | 27/2/2023 |
Dates need to be in UK format: date/month/year
Thanks!
Ben
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.
18 Replies
You can easily autofill dates in Excel Sheet. Here is the step-by-step easy guide you can follow https://tutorialdeep.com/knowhow/autofill-dates-months-time-excel/.
- 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
Are your regional settings on UK date format?
Hi Sergei,
Where do I find the option to change this?
Hello Ben
When you release the mouse after filling the cells a smart tag appears with further options.
