ReferenceExcel FormulasSupported FormulasDAYOn this pageDAY The DAY function returns the day of the month (1-31) for a given date. Syntax =DAY(serial_number) Parameters serial_number: The date for which you want to find the day of the month Examples =DAY("2023-12-25") // Returns 25=DAY(DATE(2024, 1, 15)) // Returns 15