excel autofill not working with dates

I was having the same problem and it seemed to be caused by having the data filters turned on. Enable File Handle Option. …