Category: Date and Time function
This function returns the number of days since January 1st of year date falls in.
| Argument | Type | Description |
|---|---|---|
| date | Date or Number (date serial) | An expression representing a date from which the number of days since Jan 1st is calculated. |
Return value type: Number (Integer).
YearDay does account for Leap Years in its calculation.
The argument, date, is included in the return value. See Examples, below.
yearday(#2005-01-01) //Returns 1.
yearday(#2017-05-25) //Returns 145.
yearday(#2000-12-31) //Returns 366. (A Leap Year.) yearday(#2001-12-31) //Returns 365. (A non-Leap Year.)