Ascending dates in my title rows

New 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


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



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

best response confirmed by Richard_W_Stone (New Contributor)

@Hans Vogelaar 

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