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.
