DAYOFYEAR Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2
Example 3

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.

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

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.

DAYOFYEAR("May 30, 1997 13:45:24")

Returns 150.

DAYOFYEAR(DATEVALUE("May 30, 1997")+7 ed.)

Returns 157.

DAYOFYEAR(35580.6337)

Returns 150.

Show: