Returns a integer which tells a specified date is the n-th calendar day in the year of the date.


DAYOFYEAR(year_input, month_input, day_input)

year_input - the 4-digit year to be considered.
month_input - the month (in numeric format) to be considered.
day_input - the day to be considered.


DAYOFYEAR(2000, 5, 30) equals 150, which means May 3, 2000 is the 150th calendar day in year 2000.

DAYOFYEAR(2004, 12, 31) equals 366, which means December 31, 2004 is the 366th calendar day in year 2004.