The DAY function with examples in Excel

 The DAY function in Excel allows you to extract the day of the month from a given date. Here’s how it works:

1. Basic Syntax:

   • The DAY function has the following format:

     =DAY(date)
     

   • Where:
     • date: A valid Excel date.

2. Example 1: Extracting Day from Date:

   • Suppose cell A2 contains the date “January 15, 2024.”
   • To extract the day number, use this formula:

     =DAY(A2)
     

   • This returns the value “15.”

3. Example 2: Finding Days After a Date:

   • To find the day 5 days after May 6, 2024:

     =DAY(DATE(2024, 5, 6 + 5))
     

   • The result is 11, representing the day of the month.

Remember that dates in Excel are represented as serial numbers, where January 1, 1900, is number 1.