Excel won't let me pull down dates to automatically fill out cells?

[Jyggalag]

Hi all,

I am trying to make a column of all the dates in September written in the format "dd-mm-yyyy":

However, if I write "01-09-2022" and try to pull it down (as seen above), it just keeps posting "01-09-2022": Likewise, if I try to fill out more cells with "02-09-2022" and "03-09-2022" and then mark all three cells and pull them down I will just post the rhythm of "01-09-2022, 02-09-2022, 03-09-2022" and so forth downwards

Anybody knows why, and how to fix it?

 

[arthurbr]

For one reason or another your dates are not real dates but text looking like dates.
You can check this by removing any manual alignment in your column. If your "date" moves to the left it is text.
To make it a real date, hit Data - text to column - Finish and format as required. The date should now have moved to the right side of the cell. You can now pull down