Problem with automatic dates in text form

Copper Contributor

Capture d’écran, le 2023-08-13 à 13.11.32.png



I am trying to make my dates ( in text form) automatic, so that I can go from one day to another, but the only thing that changes is the year. 


I created the two first cells to show the jump I want as an exemple, but when I try to copy it, the day and date stay the same.


As anyone experience this?


Thanks :)

1 Reply


Format the cells in that row as jjjj j mmmm aaaa (in English dddd d mmmm yyyy).

Enter 16-oct-2023 in the first cell, then drag or copy to the right.