Question

I'm trying to make a chart in Excel, but my autofill is only changing the year. Example: I typed Monday, January 18, 2015, and it fills in Monday, January 18, 2016, 17, 18 etc.. How do I fix it??

Answer 1

Update: autofill works it I type the date like 18 January 2016, but it only works if I type it that way.