I'm trying to get Google Sheets to auto-fill dates in the beneath cells after I have manually filled one myself. The strange issue is that when I hold Command key and drag down, the cells auto-populate with dates but it is the YEAR that changes, and not the day or month.
I have formatted the column with the day/month/year date pattern. I have tried adding my own custom format to the list but it doesn't allow it. It seems the sheet does recognise it as a date, but isn't understanding that I want the day to increase, not the year.