Count number of weeks in a the current month

[camila1]

Hi! I don't know how to count the number of weeks in the current month of the year or how to count the number of weeks between two dates

[MarcoWedel]

can you please post some sample data as well as your expected results, because there might be more than just one possible definition of those calculations.

thanks

Marco

[Qlik-Gerardo]

Hello @camila1 

I guess you could get the Week number for both First Day of Month (MonthStart) and Last Day of Month (MonthEnd) using today date as base date, and then substract both.

Week(MonthStart (Today()))

>> OUTPUT >> 10

Week(MonthEnd(Today()))

>> OUTPUT >> 14

14 - 10 = 4 weeks

Good luck! 

Gerardo