FUNCTION CATALOGUE / DATE & TIME
DAY Excel function
Extracts the day of the month.
Correct sentence to use
Extract the day of the month from [date].
Modify this query in PlainFormula →Example formula
=DAY(A2)
Returns day of month.
Syntax
DAY(serial_number)
Argument signature: serial_number
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.