Problem with automatic dates in text form

Copper Contributor

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

 Hi!

 

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

@erikamc2023 

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.