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.
Hi Sergei,
Not sure if it's something to do with the version I have, but I don't have the 'fill days' option available.
Hi,
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
Thanks again Sergei, for some reason this option is greyed out when I right click + drag.
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
