02-28-2017 02:20 AM
02-28-2017 02:20 AM
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:
Dates need to be in UK format: date/month/year
02-28-2017 03:44 AM
02-28-2017 04:31 AM
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
02-28-2017 07:17 AM
Not sure if it's something to do with the version I have, but I don't have the 'fill days' option available.
02-28-2017 07:46 AM
Please do the following
- be sure the date under the Mon is in proper date format
- click on this cell, it'll be selected and you'll see the dot in right bottom corner of the selection
- focus the mouse on this dot, you will see the cross
- right click the mouse on this cross (it will disaapear), keep right button pushed and drag the selection to the right till the cell under Sun
- now release the right button, menu with "Fills" will appear
- click on Fill Days
02-28-2017 09:02 AMSolution
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.
08-21-2017 07:10 PM
I need to fill a list of headers with dates every 7 days. I've never had a problem until I bought Office 2016 pro and now using fill/series and entering 7 in the step choice, doesn't work. Help
08-22-2017 01:07 AM
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)
08-25-2017 12:57 PM
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.
08-25-2017 01:18 PM
Hi Sergei, screen shot of error message below. I can follow this procedure and it works in Office 2010.
08-25-2017 03:40 PM
Not sure how it was in 2010, never use merged cells. In 2016 - yes, Series menu with defined increment doesn't work on merged cells.
However, simple Fill days, months, etc as well as Fill Series works here - enter into the first merged cell some date, in next cell the date which is on 7 days more. Select these two cells, drag by right mouse till end of your range with merged cells , Fill Series from menu.
09-17-2019 08:46 AM
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/.