Number of days in a month

[#1]

Hello,

I am trying to calculate the no of days in a particular month, and in my case it is not the normal calendar month rather a Fiscal month.

Details are attached here.

Fisc Period	Sales end of Fisc period	No of Fiscal days
201605	8909.19	28
201606	4938.3	35
201607	10999	28
201608	5487	28
201609	11878	35
201610	5489	8

in the above table, the last column is based on the Fisc_day_of_month column in the Calendar sheet.

Please let  me know if more information is needed.

[#2]

I was looking for this solution, thanks Sunny. But what is happening if i bring in another dimension say, Country to the block. It changes back to the wrong values.

[sunny_talwar]

You just need to provide all the details and we should be able to provide you the exact expression you need.

Try this:

=Max(TOTAL <Fisc_Period>{1<Date = {"$(='<' & Date(Today()))"}>}Fisc_day_of_month)