Returns the day (1..366) of the year for given a date.
Syntax DAYOFYEAR(date) Arguments date Date value to extract the day. Use the format (year, month, day) Example DAYOFYEAR(DATE(2002,7,4)) returns 185 since July 4 is the 185th day of 2002.
DAYOFYEAR(date)
DAYOFYEAR(DATE(2002,7,4)) returns 185 since July 4 is the 185th day of 2002.