Problem in Auto Filling Dates in Excel

Regular Visitor

I am trying to Auto fill Dates in my chosen Format but its response is not what i expected.

 

Eg, I have chosen to format Dates in Swiss German format. And then entering date in the form of 02.03.2021. And Expect the Dates to auto fill as 02.03.2021

                                                                             03.03.2021

                                                                             04.03.2021

                                                                             05.03.2021

But the Auto fill is responding as 02.03.2021

                                                      02.03.2022

                                                      02.03.2023

                                                      02.03.2024

Means Year is ascending but not date and Month. And I expect only date numbers to be ascending, rest remains same.

 

Please clarify.

 

1 Reply
I suspect that the "dates" are not dates but text and hence excel is just incrementing the number at the end of the text string. For example if you go under number format and choose a different date format does it change the view of the cell to that new format? I'm guessing not. So you need to enter the dates in a format Excel recognizes as a date and then fill down (fyi it is also good to do 2 or 3 and then highlight them and drag down so excel can 'see' the pattern). Then you can use number formatting to display the dates the way you want. If that date format isn't available as a default you can use Custom Format to create it DD.MM.YYYY