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

 A 1 =TODAY() = Sunday 14 August 2022 2 =NOW() = Sunday 14 August 2022 11:29:48 3 =DATE(YEAR(A1),2,1) = 01/02/2022 4 =DATE(YEAR(A1),4,1) = 01/04/2022 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

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

### 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 date 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 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.