MODLRDAY ^v2.6.131
Returns the day of the month, a number between 1 and 31, from a given date.
js
DAY(date)DAY(date)Parameters
date- The date for which to return the day of the month, represented as an Excel date value.
Examples
js
DAY("2022-04-17")DAY("2022-04-17")Result: 17
Note: Returns the day of the month (17) from the given date (2022-04-17).
js
DAY(45033)DAY(45033)Result: 17
Note: Returns the day of the month (17) from the given date (45033), represented as an Excel serial number.