Exceljet

Quick, clean, and to the point

Excel DAY Function

Excel DAY function
Summary 

The Excel DAY function returns the day of the month as a number between 1 to 31 from a given date. You can use the DAY function to extract a day number from a date into a cell. You can also use the DAY function to extract and feed a day value into another function, like the DATE function.

Purpose 
Get the day as a number (1-31) from a date
Return value 
A number (1-31) representing the day component in a date.
Syntax 
=DAY (date)
Arguments 
  • date - A valid Excel date.
Usage notes 

The DAY function returns the day value in a given date as a number between 1 to 31 from a given date. For example, with the date Janunary 15, 2019 in cell A1:

=DAY(A1) // returns 15

You can use the DAY function to extract a day number from a date into a cell. You can also use the DAY function to extract and feed a day value into another function, like the DATE function. For example, to change the year of a date in cell A1 to 2020, but leave the month and day as-is, you can use a formula like this:

=DATE(2020,MONTH(A1),DAY(A1))

See below for more examples of formulas that use the DAY function.

Note: in Excel's date system, dates are serial numbers. January 1, 1900 is number 1 and later dates are larger numbers. To display date values in a human-readable date format, apply a the number format of your choice.

Notes

  • The date argument must be a valid Excel date. 

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.