The DAY function with example in Excel formula

The DAY function in Excel allows you to extract the day of the month from a given date as an integer between 1 and 31. Let’s explore how it works and look at some examples:

1. Syntax:

   =DAY(date)
   

   • date: A valid Excel date from which you want to extract the day.

2. Purpose: The DAY function is useful when you need to work with specific day values within dates. For instance, you might want to find out which day of the month corresponds to a particular date.

3. Example: Suppose you have the following data:

   • Cell A1 contains the date “April 16, 2023.”

   To extract the day of the month from this date, use the formula:

   =DAY(A1)
   

   This will return the value 16, representing the day component of April 16, 2023.

4. Notes:

   • Excel stores dates as sequential serial numbers, where January 1, 1900, is serial number 1, and subsequent dates are larger numbers.
   • The DAY function returns an integer ranging from 1 to 31.
   • Ensure that the date argument is a valid Excel date. If it’s not, the function will return an error (#VALUE!).

Remember to replace cell reference A1 with your actual date cell.