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
You can use Networkdays function..
sorry not understood
Try this
Networkdays(startdate,enddate,holidays)
*there is no transaction date column other than holidays in you attachment
To understand it.. click on the link which I have provided..
i dont have start date and end date, in this so in that case what to do?
Provide proper data.... Along with the result you are looking for..
Both in excel file..
hi manish i have this file only, u can take continuous dates calendar.
Hi ,
do you have total count of all holidays or only default holidays are there for sunday.Please specify your requirement specifically.
Thanks
please check the attachment