=DAY(EOMONTH(B4,0)) Our DAY function is always equal to the number of days in the month. The EOMONTH function checks the date in Cell B4 and returns the date corresponding to the last day of the month we specified.
Is there an Excel formula to count days?
=DAYS (end_date, start_date)
The function requires two arguments: Start_date and End_date. They are the two dates between which we wish to calculate the number of days.
How do I calculate 30 working days in Excel?
=WORKDAY(start_date, days, [holidays])
The function uses the following arguments: Start_date (required function) – This is a date that represents the start date. Days (It is a required function) – The number of workdays to be added to start_date.