There are many date format which you can enter in the cell. So unless you're working with those data tables, it's unlikely you will ever purposely change the setting to that option. Heres How To Find Project Dates Using Excel Workday Function Microsoft Excel Formulas Excel Formula Excel I also show you a quick way to display the day. Excel autofill not working with dates . In excel, autofill date must be usually used in our daily work, but in this case, i will talk about how to fill dates by week. Key in the starting day name. Based on your description, you are using autofill to insert in a spread sheet a column with dates (january, february…). Further attempts to reproduce your issue. Quick analysis if only you select entire range. Only after manually insetting all months of the year, drag and autofill works However, when she uses the autofill handle, it just pastes the same number in every cell. The enable fill handle box is checked in excel options. To...