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

ArgumentTypeDescription
dateDate 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