Number of days in a particular month

You must also provide the year
There are four months that always contain 30 days and they are: April, June, September and November.
There is one month that always contains 28 days (except on a leap year) and that is February.
There is one month that always contains 29 days (only on a leap year) and that is February.
Cell "A1" displays the current date.
Cell "A2" displays the current date and time.
Cell "A3" displays the first day of February in the current year.
Cell "A4" displays the first day of April in the current year.
Cell "A5" displays the number of days in the current month of the current year using EOMONTH.
Cell "A6" displays the number of days in the current month of the current year using DATE, YEAR and MONTH.
Cell "A7" displays the number of days in the month of April of the current year using EOMONTH.
Cell "A8" displays the number of days in the month of April of the current year using DATE, YEAR and MONTH.
Cell "A9" displays the number of days in the month of February of the current year using EOMONTH.
Cell "A10" displays the number of days in the month of February in the leap year 2024.

 A
1=TODAY() = 02/12/2019
2=NOW() = 12/2/2019 7:03
3=DATE(YEAR(A1),2,1) = 01/02/2019
4=DATE(YEAR(A1),4,1) = 01/04/2019
5=DAY(EOMONTH(A1,0)) = 31
6=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1) = 31
7=DAY(EOMONTH(DATE(YEAR(A3),4,1),0)) = 30
8=DAY(DATE(YEAR(A3),4+1,1)-1) = 30
9=DAY(EOMONTH(A3,0)) = 28
10=DAY(DATE(2024,3,1)-1) = 29

Built-in Functions

DATE - The date as a date serial number given a year, month, day.
DAY - The day as an integer given a date serial number.
EOMONTH - The serial number of the last day of a month before or after a date.
MONTH - The month as an integer given a date serial number.
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 months between 2 dates
Number of days between 2 dates
Number of days in a particular year
Number of days left in the current month
Number of days left in the current year


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