Nov 21 2021 11:44 AM
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.
Nov 21 2021 12:05 PM
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.
Nov 21 2021 01:47 PM
Nov 21 2021 01:49 PM
Do you use R1C1 notation? If so, use =R[-1]C
Nov 21 2021 11:07 PM
SolutionThis now performs as I wanted. Question solved! Danke Hans, dit was net wat ik zookt.