DAY Function

Returns the day of the month from a date.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

A number from 1 to 31

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

Overview

DAY reads a date and returns its day of the month, from 1 to 31.

Pair it with MONTH and YEAR to take a date apart, or with DATE to rebuild it with one part changed.

Syntax

=DAY(serial_number) Explain

Arguments

ArgumentRequired?What it does
serial_numberYesThe date — a cell, a DATE formula or a date serial number.

Examples

Example 1 — Day of each order

Pull the day out of Northstar's order dates.

B2fx=DAY(A2)
AB
1Order dateDay
23/15/202615
37/4/20264
412/31/202631
=DAY(A2) Explain

Example 2 — Flag orders in the first half of the month

Combine DAY with IF.

=IF(DAY(A2)<=15, "1st half", "2nd half") Explain

Common mistakes

  • DAY returns 0. The cell is empty (an empty cell counts as day 0 of January 1900). Check the reference.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.