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 |