How Calculate the number of weeks per month

[Anonymous]

Hi all,

I want to calculate number of weeks per month and it should be displayed  in the Text Object.

For example :

   if i click on Jan it should show no of weeks in Jan that should be displayed in Text Objects. can any one help on this.

Thanks & Regards,

Sivakumar

[Anonymous]

do you have a calendar wit year,month,week, day?

then getpossiblecount(week) should do it, if you click on january (the year as well Jan 2014) the number of weeks should be displayed

Hope it helps

[kushalthakral]

Hi Sivakumar

you can try the below formula (used with Today() but u can change according to you)

week(monthend(today()))
-
week(MonthEnd(addmonths(Today(),-1,0)))

Regards

Kushal Thakral

[maleksafa]

you should create a master calendar in your schema having the week number using the week() function.