syntax:functions:yearday
Table of Contents
YearDay(date)
Category: Date and Time function
Description
This function returns the number of days since January 1st of year date falls in.
Arguments
| 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).
Remarks
YearDay does account for Leap Years in its calculation.
The argument, date, is included in the return value. See Examples, below.
Examples
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.)
See also
syntax/functions/yearday.txt · Last modified: 2021/10/15 15:23 by craigt