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.


Related Formulas

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


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