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

[MK_QSL]

You can use Networkdays function..

function:networkday

[abhaysingh]

sorry not understood

[sasikanth]

Try this

Networkdays(startdate,enddate,holidays)

*there is no transaction date column other than holidays in you attachment

[MK_QSL]

To understand it.. click on the link which I have provided..

[abhaysingh]

i dont have start date and end date, in this so in that case what to do?

[MK_QSL]

Provide proper data.... Along with the result you are looking for..

Both in excel file..

[abhaysingh]

hi manish i have this file only, u can take continuous dates calendar.

[deepakqlikview_123]

Hi ,

do you have total count of all holidays or only default holidays are there for sunday.Please specify your requirement specifically.

Thanks

[sasikanth]

please check the attachment