Get Day from Date in Excel – Easy Guide 2021

This Guide covers how to get Day from Date in Excel. Here we have used two different methods – First Method uses TEXT function and Second function used Custom Cell format to get day from date in Excel.

EXCEL GET DAY NAME FROM DATE

GET DAY NAME FROM DATE USING TEXT FUNCTION IN EXCEL

In this method we use TEXT function; TEXT function converts date to DAY name. Input can either be provided in form of cell reference or directly inputting date.

Syntax

=text(A1,”ddd”)
GET DAY NAME FROM DATE  IN EXCEL
Get Day name using Text Function

Here we have provided cell reference and we will get output as Day Name. Output is provided as forma specified i.e. “ddd“. Output here will be as Mon for Monday, Tues for Tuesday and so on.

Syntax

=text(A1,”dddd”)

Here output will be in as Full name of Day i.e. Monday, Tuesday and so on.

GET DAY NAME FROM DATE IN EXCEL
Get Day name using Text Function

Note: If you want to use this Day name in further calculation remember when using TEXT function output is only text all not other details which were used for input are lost.

GET DAY NAME FROM DATE USING NUMBER FORMAT

Here we simply change format of cell and date will be shown as Day in same cell. We use either of custom formats i.e. “ddd” or “dddd“. Cell format can be changed by right clicking on cell and then click on Format Cell.

To change of Right Click on cell with Date and select Format. Now under number tab select Custom category and in type box enter ddd to get abbreviated day or dddd to get complete day.

Abbreviated short form (Sun, Mon…..)
Full Day name (Sunday, Monday…..)

Advantage of using this method date information is not lost. Day can be reverted to date by simply changing format.

This guide applies to excel 2007 onwards