How can i find the number of days in the month?
=Num(MonthStart(Max(DateField)) - MonthEnd(Min(DateField)))
Change the DateField according to your requirement.
Or simply try
=day(monthend(today() ) )
If you already have year and month calculated from date. You can use below expression
Try like this
Num(MonthStart(DateField) - MonthEnd(DateField) + 1) AS NumberOfDaysInMonth
Hope this helps you.
Retrieving data ...