How to Insert Day and Date in Excel – 3 Methods

This is the sample dataset.

3 Ways to Insert Day and Date in Excel


Method 1 – Using the TEXT Function to Insert Day and Date

Steps

  • Select Cell C5 and enter the following formula:

=TEXT(B5,"dddd")

  • Cell C5 displays the name of the day of the dates in Cell B5.

Use of TEXT Function to Insert Day and Date in excel

  • Hold the Fill Handle at the corner of C5 and drag it down to C14.
  • All dates in the Days column display the name of the days.

Use of TEXT Function to Insert Day and Dates

Read More: How to Insert Date in Excel Formula


Method 2 – Using Number Formatting in Excel

2.1 From the Ribbon

Steps

  • To add the name of the day, select dates and go the Home tab>Number> number formatting.

Using Number Formatting in Excel to insert day and date in excel

  • Select Long Date, which includes the date with the name of the day.

Using Number Formatting in Excel

All your dates have the corresponding name of the day.

Using Number Formatting in Excel to insert day and date in excel

Read More: How to Insert Current Date in Excel


2.2 From the Context Menu

Steps

  • To add the name of the day to the dates, select the dates.

Using Number Formatting in Excel

  • Right-click to open the context menu. Select Format Cells.

Using Number Formatting in Excel

  • In the new window click Number. 
  • Select Date in Category.
  • In Type, select the format with date and name of the day.
  • Click OK.

Using Number Formatting in Excel

All dates display the name of the day.

Using Number Formatting in Excel

Read More: Automatically Enter Date When Data Entered in Excel


Method 3 – Applying the Custom Number Formatting in Excel

Steps

  • Select B5:B14.

Applying Custom Number Formatting

  • Right-click to open the context menu.
  • Select Format Cells.

Applying Custom Number Formatting

  • In the new window, click Number. 
  • Select Date in Category.
  • In Type, select the m/d/yyyy format.
  • Click OK.

Applying Custom Number Formatting

Note

dddd” will add the name of the day in full form. If you want the format to be an abbreviation , enter “ddd”.

  • Click OK, and all dates display the name of the day.


Download Practice Workbook

Download the practice workbook below.


Related Articles


<< Go Back to Insert Date | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rubayed Razib Suprov
Rubayed Razib Suprov

Rubayed Razib, holding a BSC degree in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a devoted member of the ExcelDemy project. He has contributed significantly by authoring numerous articles and showcasing proficiency in VBA. Razib efficiently automates Excel challenges using VBA macros and actively participates in the ExcelDemy forum, providing valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo