# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for
Did you mean:
Not applicable

## Find number of days in present month

Hi all,

How can i find the number of days in the month?

Regards,

Pramod

1 Solution

Accepted Solutions
Champion

=Num(MonthStart(Max(DateField)) - MonthEnd(Min(DateField)))

Change the DateField according to your requirement.

Or simply try

=day(monthend(today() ) )

5 Replies
Champion

=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

= sum(aggr(count(Date),Year,Month))

Champion

something like:

= sum(aggr(count(day(Date)),Month))

Partner

Hi,

Try like this

*,

Num(MonthStart(DateField) - MonthEnd(DateField) + 1) AS NumberOfDaysInMonth

FROm DataSource;

Hope this helps you.

Regards,

jagan.

MVP

Day(Monthend(Today()))