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() = Thursday 01 December 2022
2=NOW() = Thursday 01 December 2022 06:02:29
3=TODAY()-365 = 01/12/2021
4=TODAY()-(2*365) = 01/12/2020
5=TODAY()-(3*365) = 02/12/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

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 certain 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.


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