Forum Discussion
Richard_W_Stone
Nov 21, 2021Copper Contributor
Ascending dates in my title rows
I would like to format the rows to show a date like this Mo 11/14 and automatically the next following row Tu 11/15 and so on down the column changing the months when appropriate.
This now performs as I wanted. Question solved! Danke Hans, dit was net wat ik zookt.
4 Replies
Enter the start date in the first cell, say in A2.
In the next cell, enter the formula =A2+1
Format both cells as Format it as ddd mm/dd
Select the second cell and fill or copy down as far as you want.
- Richard_W_StoneCopper Contributor
Do you use R1C1 notation? If so, use =R[-1]C