Days in Month Formula
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))
Please note: I reserve the right to delete comments that are offensive or off-topic.