Display current month working days in a message box

[aman1234]

Hi guys

I have a access table with two fields named as "Month" and "Bank Holidays". I have put names of the month in this table for 2014 and the corresponding bank holidays of each month. Now I want to write down the piece of code that will execute when a button on the userform is pressed and it should check the current month of the year and then display the total working days ( After subtracting bank holidays of that month and weekends of that month from the total working days of that month).

Can anyone please help me in this?

Regards,
Aman

[aman1234]

Hi guys

Can anyone please help me in this?

Thanks

[aman1234]

Hi guys

The following coee in MS Access works fine but I want to convert into Excel/vba.

I hope anayone can help me in this.

Please Login or Register  to view this content.

Thanks

[Lukael]

What about Networkdays function, tried that in VBA ? I'm not an expert, but It works when you insert It on a sheet, holidays can be made in a list. But you'd had to do this in VBA, not sure how...