# Number of days in a particular year

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

Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
Cell "A3" displays 365 days before that date.
Cell "A4" displays (2*365) days before that date.
Cell "A5" displays (3*365) days before that date.
Cell "A6" displays the number of days in the current year.
Cell "A7" displays the number of days in the previous year.
Cell "A8" displays the number of days in the year of the date in cell "A4".
Cell "A9" displays the number of days in the year of the date in cell "A5".
Cell "A10" displays the number of days in the year 2010.
Cell "A11" displays the number of days in the year 2000.

 A 1 =TODAY() = Sunday 01 May 2022 2 =NOW() = Sunday 01 May 2022 18:37:54 3 =TODAY()-365 = 01/05/2021 4 =TODAY()-(2*365) = 01/05/2020 5 =TODAY()-(3*365) = 02/05/2019 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 = 366 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

### Built-in Functions

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