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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.