Count number of Days of a Month

[#1]

Hi

a) I need to do an average from some data. But for this, I need to know how many days are in a certain month.

     How can I get this number?

i.e. February 2014   -->  28 (days)

b) I need to get the number of Mondays,Tuesday, and so on in a certain month. ¿How can I get this?

i.e. January 2014 --> 5 Mondays

      January 2014 --> 4 Tuesday

      January 2014 --> 4 Wednesday

[#2]

I'm using a Master Calendar for my dates.

It has the following fields:

a) %Date Field                         25-01-2014, 26-01-2014

b) Day Name field               Monday,Friday,Tuesday

c) Month                             January, February...

(and much more)

[#3]

Hi,

1) Max(day(datefield)) - Min(day(datefield))

[maleksafa · Accepted solution]

to get the count of mondays for example you can simply use count({<[Day Name Field] = {'Monday'}>}  [Day Name Field]) you can do the same for the rest of the days.