SOLVED

Ascending dates in my title rows

Copper Contributor

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.

4 Replies

@Richard_W_Stone 

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.

@Hans Vogelaar

Did as suggested but the second cell returns a #NAME error

 

@Richard_W_Stone 

Do you use R1C1 notation? If so, use =R[-1]C

best response confirmed by Richard_W_Stone (Copper Contributor)
Solution

@Hans Vogelaar 

This now performs as I wanted. Question solved! Danke Hans, dit was net wat ik zookt.

1 best response

Accepted Solutions
best response confirmed by Richard_W_Stone (Copper Contributor)
Solution

@Hans Vogelaar 

This now performs as I wanted. Question solved! Danke Hans, dit was net wat ik zookt.

View solution in original post