# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Find number of days in present month

Hi all,

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

Regards,

Pramod

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: Find number of days in present month

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

Change the DateField according to your requirement.

Or simply try

=day(monthend(today() ) )

5 Replies
MVP

## Re: Find number of days in present month

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

Change the DateField according to your requirement.

Or simply try

=day(monthend(today() ) )

MVP

## Re: Find number of days in present month

If you already have year and month calculated from date. You can use below expression

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

Esteemed Contributor

## Re: Find number of days in present month

something like:

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

MVP

## Re: Find number of days in present month

Hi,

Try like this

LOAD

*,

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

FROm DataSource;

Hope this helps you.

Regards,

jagan.

MVP

## Re: Find number of days in present month

Day(Monthend(Today()))