Excel Date Formatting / Date Formatting in MS Excel.

Date Formatting / Excel Date Formatting:- 

Show Weekdays Next To Dates in Excel Spreadsheet / Fill Day with Dates in the same column / cell or in the next cell / column in Microsoft (MS) Excel.

Here is a very quick easy trick to fill / show days name next to the dates either in the same column or in the next column of the dates in MS Excel spreadsheet. Every person should use dates in proper format in their spreadsheet especially when you are a profession and working in a corporate world. When a person type a date in Microsoft Excel, it often displays the dates in a different format than the way you typed the dates.

If you want to display your date exactly as you typed you can use the apostrophe (') symbol before the dates you are typing. But here their is a problem with this method, it restricts the possibilities that real dates give you in Excel. Many users use / opt for typing  / inserting an apostrophe (')  before their dates.



Instead of the above method (Inserting / putting apostrophe before date), excel users have many more possibilities for displaying their dates exactly the way you want with the help of Custom Number Formatting in Excel.

With the help of Custom Number Formatting in MS Excel we can do many things in which here we are going to displaying weekdays next to dates in same column or in next column / Cell.

Below are two options using Cusstom Number Formatting that you can use to display weekdays next to dates in your Excel Worksheets.

First we are goint to display weekdays in separate column or cell in Excel.
1) To Enter the current date in Excel Press CTRL+; and drag the Fill Handle down to create a series of dates, lets fill the dates in cells B3:B14 just for an example (You can Enter any date as you want).

2) Now, in cell C3 type =B3 and Drag the Fill Handle down till C14 (or Double click the lower right corner of the selected i.e C3 cell).

3) Select the filled dates i.e C3:C14, open Format Cells dialog box from the Font group in the Home Menu by clicking the lower right corner of Fond group or You can press simply CTRL+SHIFT+F ( to open Format Cells dialog box press CTRL+1).

4) In Format Cells dialog, click the custom category on the Number tab (uper left corner), next to the category list type / enter dddd in Type field and click ok.

Now weekday for each date in column B will show in a separate column (Column C)

Now if you want to include / fill weekday in same cell that contains / have date, follow the below method:-
1) Select the date cells in column B (B3:B14) and press CTRL+1 to open the Format Cells dialog;

2) On the Number tab, click the Custom category. In the Type field enter dd-mmm-yy (dddd) and click OK.

If you want to show / add weekday before the date you can add the dddd at the begining of the format. And, if you want to display only three character for the weekdays you can type / add / enter ddd instead of dddd.

Now all you wanted you have it. A weekday name and date displayed in the same cell in MS Excel worksheet.