Date range

Occasional Visitor

Im making a schedule. i would really like for it to be formatted "Monday 1/31/22" and then auto fill

the rest of the days of the month. i can get it to populate with just the 1/31/2022 but how do i get it to also add the text for the day of the week?

1 Reply
If you go into number/cell format and then select custom and type: dddd m/d/yy
that will create the custom format you are asking for. Note you have a lot of options/controls there. For example ddd mm/dd/yyyy would give you Mon 01/31/2022 (i.e. 3 character day, force 2 digits for month and day and 4 digits for year).