DAY Function
Purpose
Returns the day of the month, a number from 1 to 31, given a date serial number.
Syntax
EXCEL
=DAY(serial_number)
Arguments Breakdown
| Argument | Required? | Description |
|---|---|---|
serial_number |
Required | The date of the day you are trying to find. |
Practical Examples
1. Extract Day Component Drill
From Formulas_&_Functions_Part_2.xlsx (Sheet Date and Time ):
EXCEL
=DAY(TODAY())
Returns current day of month integer (e.g. 29).
2. End-of-Month Billing Flag
EXCEL
=IF(DAY(A2) >= 28, "Billing Cycle 4", "Standard Cycle")
Related Knowledge
- Notes: 06 Date and Time Intelligence
- Workbook:
11_Demos_and_Workbooks/03_Formulas_and_Functions/Formulas_&_Functions_Part_2.xlsx(Sheet:Date and Time)