Forum Discussion
Excel Date Autofill
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.
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.
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
Hi Sergei, That works - thanks. Des
Hi Des,
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.
Hi Sergei, screen shot of error message below. I can follow this procedure and it works in Office 2010.
Thanks, Des
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.
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)