Number days worked by month

[#1]

Hello,

I need to get the number of days by month, but I must substract the saturdays and sundays of this number.

Example for November : I must get 22 days.

I don't know how I can do.

thanks for your help.

[#2]

You could do something like this...

Weekday(Date) as WeekDay

Count(Weekday)

[swuehl]

Do you have a calendar with Date, Month, Year etc.?

Then create a table chart with dimension Month (or YearMonth), and as expression use:

=networkdays(monthstart(Date),monthend(Date))

If you use a Month or YearMonth of date type, you could also use these as field in the above expression.

Hope this helps,

Stefan

[#4]

no, I have nothing.

I'm in the script, and I need to create 1 variable by month.

var_01_2011 = 20

var_02_2011 = 18

var_03_2011 = xx

var_04_2011 = xx

...

These variables will be used in a mathematics calculs.

[#5]

Hello Prophete.

Is something like this:

=COUNT(if(Num(WeekDay(DATE_FIELD)) < 5, DATE_FIELD))

Good Luck

Bruno Oliveira

[#6]

Thanks you.

My problem is solved with the functions :

set X = networkdays(monthstart(Y) , monthend(Y));