Forum Discussion
erikamc2023
Aug 13, 2023Copper Contributor
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
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.