DAY Function in Excel

The DAY function in Excel returns the day of the month as a number between 1 to 31. We will go through several usage examples and how the DAY Function can be combined with other functions. We will also address a common error.




  • serial_number – (required) Must be a valid date in Excel, serial number, or reference to a date in a cell.

Day Function Usage Example:

Returns a value 1 to 31 from a specified date.

Day Function
DAY Function in Excel

Usage Errors

You may receive an error that ends in 1900. Don’t freak out. All this means is the cell, B4, is formatted as a date instead of a Number.

Day Error

Other Usage Examples:

You can use the DAY Function within other formulas. You can also add, subtract, divide, and multiply as shown below.

DAY Function Examples

Leave a Reply

Match Function

Match Function The Match Function searches for a specified value and returns relative position of that value. It’s easier once

Read More »

RAND Function

The Excel RAND function returns a random number between 0 and 1. This is a rather simple function in Excel,

Read More »
Scroll to Top