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() = Tuesday 01 October 2024
2=NOW() = Tuesday 01 October 2024 06:08:01
3=TODAY()-365 = 02/10/2023
4=TODAY()-(2*365) = 02/10/2022
5=TODAY()-(3*365) = 02/10/2021
6=DATE(YEAR(A1), 12, 31)-DATE(YEAR(A1), 1, 1)+1 = 366
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 = 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 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.


User Defined Function

DAYSINAYEAR - Returns the number of days in a particular year.


Related Formulas

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


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