Number of days in a particular year

You can return the number of days in a year taking leap years into account.

Example

	A
1	=TODAY() = Friday 29 November 2024
2	=NOW() = Friday 29 November 2024 11:44:05
3	=TODAY()-365 = 30/11/2023
4	=TODAY()-(2*365) = 30/11/2022
5	=TODAY()-(3*365) = 30/11/2021
6	=DATE(YEAR(A1), 12, 31)-DATE(YEAR(A1), 1, 1)+1 = 366
7	=DATE(YEAR(A3), 12, 31)-DATE(YEAR(A3), 1, 1)+1 = 365
8	=DATE(YEAR(A4), 12, 31)-DATE(YEAR(A4), 1, 1)+1 = 365
9	=DATE(YEAR(A5), 12, 31)-DATE(YEAR(A5), 1, 1)+1 = 365
10	=365+IF(MOD(2010, 4), 0, 1) = 365
11	=365+IF(MOD(2000, 4), 0, 1) = 366

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
3 - Displays 365 days before that date.
4 - Displays (2*365) days before that date.
5 - Displays (3*365) days before that date.
6 - Displays the number of days in the current year.
7 - Displays the number of days in the previous year.
8 - Displays the number of days in the year of the date in cell "A4".
9 - Displays the number of days in the year of the date in cell "A5".
10 - Displays the number of days in the year 2010.
11 - Displays the number of days in the year 2000.

Built-in Functions

DATE - The date as a date serial number given a year, month, day.
IF - The value based on whether a condition is True or False.
MOD - The remainder after division.
NOW - The date serial number of the current system date and time.
TODAY - The date serial number representing today's date.
YEAR - The year as an integer given a date serial number.

User Defined Function

DAYSINAYEAR - Returns the number of days in a particular year.

Related Formulas

Number of days in a particular month
Number of days between 2 dates