Holiday Working question

[abhaysingh]

I have one table in which Total holidays dates are present,

i want total working days to count which is Count(Total Days of Month) - Count(Holidays)

getting some glitch in output pls suggest.

pls find the attached sample data for holidays

[#2]

I have no permission to open this file. Could you help to copy the expression to me? many thanks

[abhaysingh]

Hi Anton,

Your solution is was working for me perfectly but stuck at one side,

Till now in current i was getting the data off all month, some entry holidays dates in month and solution working fine.

but when there is no leave in a month, all day of the month are working than it is not giving me any thing.

i want when no holiday date given than it should pick no of days of that month.

actually i want to show production days, if production goes for all day of month in that case it shud show total number of days of that month.

Pls suggest

Regards

Abhay