how to calculate the number of weekdays between 2 date fields?

[lalitkgehlot89]

Hi,

I have a very simple question, how to calculate the number of weekdays between 2 date fields?

like in Jan 1/1/2016-31/1/2016

Mon-- 4

Tue-- 4

Wed-- 4

Thr-- 4

Fri-- 5

Sat-- 5

Sun-- 5

[swuehl]

Create a master calendar.

The Master Calendar

Then select a data range, e.g. a Month field value from the calendar.

Create a straight table chart with dimension WeekDay and as expression

=Count(WeekDay)

[tobiasloe_dv]

You could use the function NetWorkDays(start_date, end_date)