Power Query
published
Search
⌃K

Date.DayOfYear

Date.DayOfYear

Returns a number from 1 to 366 representing the day of the year.
function (optional dateTime as nullable any) as nullable any

Description

Returns a number representing the day of the year in the provided date, datetime, or datetimezone value, dateTime.

Category

Date

Examples

The number of the day March 1st, 2011 (#date(2011, 03, 01)).
Date.DayOfYear(#date(2011, 03, 01))
60