DAYSINYEAR function

CALC FUNCTIONS

Date & Time Functions

< Previous Section

Next Section >

FUNCTIONS

• TODAY
• NOW
• YEAR
• MONTH
• DAY
• WEEKDAY
• HOUR
• MINUTE
• SECOND
• DATE
• DATEVALUE
• TIME
• TIMEVALUE
• EOMONTH
• EDATE
• WORKDAY
• NETWORKDAYS
• DAYS
• DAYS360
• DAYSINMONTH
• DAYSINYEAR
• WEEKS
• WEEKSINYEAR
• WEEKNUM
• WEEKNUM_ADD
• MONTHS
• YEARS
• ISLEAPYEAR
• EASTERSUNDAY
• YEARFRAC

< Previous Page

Next Page >

DAYSINYEAR

Returns the number of days in a year.

This function is only available if the Analysis AddIn is installed.

Syntax:

DAYSINYEAR(date)

returns the number of days in the year in which date lies.

Example:

DAYSINYEAR("2012-02-14")

returns 366, the number of days in 2012 (2012 is a leap year).

Issues:

DAYSINYEAR is not part of the ODFF international standard, and is not portable. Try 365+(MONTH(DATE(YEAR(date);2;29))=2) if you wish a portable result.

---

See Also

• ISLEAPYEAR
• WEEKSINYEAR
• DAYSINMONTH
• DAYS

• Date & Time overview

• Date & Time functions

• Functions listed alphabetically
• Functions listed by category