# 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() = Tuesday 10 September 2024 2 =NOW() = Tuesday 10 September 2024 10:51:43 3 =TODAY()-365 = 11/09/2023 4 =TODAY()-(2*365) = 11/09/2022 5 =TODAY()-(3*365) = 11/09/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.