Extract Day from Date – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on August 26, 2023
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to extract the day number from a date in Excel and Google Sheets.

Extract Day from Date Main


Extract Day from Date

DAY Function

Extracting the day part of a date is really straightforward using the DAY Function:


extract day from date 01

The DAY Function returns the day from a date.

Day From Date Stored as Text

If your Date is stored as text, first you must convert it from text to a valid date:



Date Format: Show only Day

Another way to display only the day part of a date is simply changing the cell to a custom date format. Select the date, then go to Format Cells > Custom, and enter one of these formats: dddd, ddd, dd, d.

DD Date Format

In this example, the cell value is still the date March 12, 2020, but it is displayed as the number 12. Any formulas referring to B3 will recognize it as a date and not the number 12.

TEXT Function

Another option is the TEXT Function with the format “dd”.


extract day from date TEXT

In this example, we’re displaying the number 12 as text.

For more information on getting day name from date, please read this article day-name-from-date.


Extract Day from Date in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.

extract day from date Google Function

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List