Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I have no permission to open this file. Could you help to copy the expression to me? many thanks
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