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() = 02/12/2019
2=NOW() = 12/2/2019 7:03
3=TODAY()-365 = 02/12/2018
4=TODAY()-(2*365) = 02/12/2017
5=TODAY()-(3*365) = 02/12/2016
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

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.


Related Formulas

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


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top