Date Formatting

[Atrow2025]

I want to create an autofill column where it says (Day of the week, Month, day ) So it would say Monday January 18 for example. How do I do this since there is no formula I can find that does exactly this?

[#2]

@Atrow2025 

Enter the starting date in a cell, say in B2.

In the cell below it, enter a formula that adds 1 (day) to this date:

=B2+1

Fill or copy the formula down as far as you need/want.

Apply the following custom number format to the range with the dates:

dddd mmmm d