DAYOFYEAR Function
Returns an integer, 1 to 366, that represents the sequential day of the year in datetime or expression. The DAYOFYEAR function uses the Gregorian calendar.
Syntax
DAYOFYEAR("datetime"|expression[,lcid])
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
datetime |
Required |
String |
Any string commonly recognized as a date and time or a reference to a cell containing a date and time. |
expression |
Required |
String |
Any expression that yields a date and time. |
lcid |
Optional |
Number |
Specifies the locale identifier to be used in evaluating a non-local datetime. The locale identifier is a number described in the system header files. |
Return Value
Integer
Remarks
Any time component in datetime or expression is discarded.
The result corresponds to January 1 to December 31. No rounding is done. If datetime is missing or cannot be interpreted as a valid date or time, the function returns an error.
The DAYOFYEAR function also accepts a single number value for expression where the integer portion of the result represents the number of days since December 30, 1899.
Example 1
DAYOFYEAR("May 30, 1997 13:45:24")
Returns 150.
Example 2
DAYOFYEAR(DATEVALUE("May 30, 1997")+7 ed.)
Returns 157.
Example 3
DAYOFYEAR(35580.6337)
Returns 150.