# 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 01 September 2023 2 =NOW() = Friday 01 September 2023 06:34:19 3 =TODAY()-365 = 01/09/2022 4 =TODAY()-(2*365) = 01/09/2021 5 =TODAY()-(3*365) = 01/09/2020 6 =DATE(YEAR(A1),12,31)-DATE(YEAR(A1),1,1)+1 = 365 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 = 366 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.