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.
Are your regional settings on UK date format?
Hi Sergei,
Where do I find the option to change this?
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
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
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