### 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.
Cell "A2" displays the current date and time.
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() = Wednesday 11 August 2021 2 =NOW() = Wednesday 11 August 2021 16:06:50 3 =TODAY()-365 = 11/08/2020 4 =TODAY()-(2*365) = 12/08/2019 5 =TODAY()-(3*365) = 12/08/2018 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 = 366 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

#### Built-in Functions

DATE - The date as a date serial number given a year, month, day.
IF - The value based on a logical test that is either 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.