1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. DAYSINYEAR

Use the DAYSINYEAR function to determine the number of days in a specified year.

For example, you can use the DAYSINYEAR function to find out that 2015 had 365 days, and 2016 had 366 days.

Syntax

DAYSINYEAR(year)

The DAYSINYEAR function has the following arguments:

Argument Data type Description
year (required)

Number

The year you want to find the number of days for.

Constraints

This function has no constraints.

Examples

The following table shows some example formulas using the DAYSINYEAR function.

You can enter values directly into your formula, or reference line items or list properties.

Formula Description Result
DAYSINYEAR(Product.Year)

This example shows how you can include line items or list properties in your formula. In this example, the value of Product.Year is 2014.

365

DAYSINYEAR(2015)

The number of days in 2015.

365

DAYSINYEAR(2016)

The number of days in 2016.

366

Excel equivalent

YEAR