Working Days per month

[pnagames]

does anyone know where i can get the number of working days per month fromApril 07 onwards?

[Paragon]

Excel can do it

You can do this in excel:

http://www.excelexchange.com/WorkingDays.html

[Darren B]

by the time you have messed around it would have been quicker to count the days on a calender, if you use excel remember bank holidays

[pnagames]

Steve

not what i want (as i need the working days excluding bank hols)

D, i did not want to use excel for that reason (or even the pc calendar)

i was hoping that someone knew about a site that had this

[Mike Hughes]

The solution steve points to already has the English bank holidays excluded.

Mike

[pnagames]

Hi Mike

thanks for pointing it out

now if i could make Excel 07 recognise the function i would be flying

[Darren B]

The solution steve points to already has the English bank holidays excluded.

Mike

Well i never knew that - Thanks Mike

[pnagames]

yyyeaaaaaahhhhh.....

sortted

thanks to everyone

[Mike Hughes]

You have to create the function using the code given.

I can do this in excel 2000 but the answer always appears to be 0 which isn't too helpful. I'll need to take a look at this later and see what's going on. The code looks simple enough.

Mike

edit: Ah. I see it's now sorted. good.

[pnagames]

yeap

you need to add the code in a module in the VBA (i should have remember this)

then excel recognise the function