DAYOFYEAR

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

Syntax

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.

Example

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.