Forum Discussion

erikamc2023's avatar
erikamc2023
Copper Contributor
Aug 13, 2023

Problem with automatic dates in text form

 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.

Resources