Forum Discussion
Excel fill function only changes the year
susannewalter You need to enter a valid date first, in the format that your Excel understands. You mentioned that your local setting are 7/1/2021 for the 1st of July. So, your systems is set-up to work with US style dates (M/D/Y). If you want to work with European style dates (D/M/Y), you can change the regional settings on your PC, or first enter a date US style and then use the custom format to change it.
There's not much more I can tell. Perhaps the link below helps.
I do the following:
I enter a date into a cell (say 1.7.21), I go to Custom - I choose a different format - it doesnt change my entry to the new format, and it also switches the assigned category to Date. It also doesnt increment when I drag it across (only the year changes, as before).
Can you walk me through step by step again what you have done to get the lined up dates right, in row 12.
susannewalter You need to enter a valid date first, in the format that your Excel understands. You mentioned that your local setting are 7/1/2021 for the 1st of July. So, your systems is set-up to work with US style dates (M/D/Y). If you want to work with European style dates (D/M/Y), you can change the regional settings on your PC, or first enter a date US style and then use the custom format to change it.
There's not much more I can tell. Perhaps the link below helps.
- Ok, I think I understand it now better. I actually just changed the regional formatting again and it seems to recognize dates now. Many thanks for your support, that was very helpful. Thanks!