Formula to Count Days of Month

Showcase Tips and Hacks
1

I needed a formula to return the days in a month from any given date and came up with the solution below. Wanted to share it here for anyone in need.

(EndOfMonth([Date],0)-([Date].DateStartOf("month")))+1
2

This one will save you a couple of keystrokes:
EndOfMonth([date],0).Day()

2 Likes
3

Even better. Thanks!