Functions
DAY
Day of month from a date serial number
Try it
When to use it
When should I use DAY instead of WEEKDAY?
Use DAY to get the day-of-month number (1-31) from a date; use WEEKDAY to get the day of the week (1-7).
Use cases
Find the last day number of a month with EOMONTH
Check whether a date falls on the first of the month
Used in
finance · operations · hr
Syntax
DAY(date)Examples
=DAY(DATE(1969,7,20)) // => 20
=DAY(40909) // => 1
=DAY("7/20/1969") // => 20