Syntax
DAY(Date)
Date (required) – This is the date value that you want to return the day from.
Example
In this example we use the function on several dates in different formats. Notice the text values we try result in a #VALUE! error while numerical values outside of the range 1 to 2,958,465 result in a #NUM! error.
