If you need to calculate how many days in a month, you can use two functions together.
Assuming cell A1 has a date within the month, you can use
=DAY(EOMONTH(A1,0))
If you need to calculate how many days in a month, you can use two functions together.
Assuming cell A1 has a date within the month, you can use
=DAY(EOMONTH(A1,0))