Date Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2071239%22%20slang%3D%22en-US%22%3EDate%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071239%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20an%20autofill%20column%20where%20it%20says%20(Day%20of%20the%20week%2C%20Month%2C%20day%20)%20So%20it%20would%20say%20Monday%20January%2018%20for%20example.%20How%20do%20I%20do%20this%20since%20there%20is%20no%20formula%20I%20can%20find%20that%20does%20exactly%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2071239%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2071296%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071296%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F933389%22%20target%3D%22_blank%22%3E%40Atrow2025%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEnter%20the%20starting%20date%20in%20a%20cell%2C%20say%20in%20B2.%3C%2FP%3E%0A%3CP%3EIn%20the%20cell%20below%20it%2C%20enter%20a%20formula%20that%20adds%201%20(day)%20to%20this%20date%3A%3C%2FP%3E%0A%3CP%3E%3DB2%2B1%3C%2FP%3E%0A%3CP%3EFill%20or%20copy%20the%20formula%20down%20as%20far%20as%20you%20need%2Fwant.%3C%2FP%3E%0A%3CP%3EApply%20the%20following%20custom%20number%20format%20to%20the%20range%20with%20the%20dates%3A%3C%2FP%3E%0A%3CP%3Edddd%20mmmm%20d%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

1 Reply

@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