Days in month

By using both the Day function and the EOMONTH function, we can find the number of days in a given month e.g. to find how many days are in the month of Oct.

Example

Formula:

Result:

How the formula works

The formula used above is:

=DAY(EOMONTH(A4,0)) where the DAY function is used to find days in a month, a number from 1 to 31 and the EOMONTH function is used to return a date corresponding to the last day of the month.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved