calculate working days in a month

[jhowardcarter]

Hi,

How could I calculate the number of working days in a month (monday to friday, excluding weekends). Also I'd need to return the current working day.

I appreciate this may not be exact allowing for B/Hols's etc.

Thanks,

jmhc

 

[CR85user]

If you use the formula Ken Hamady made available on his website:

http://kenhamady.com/form01.shtml

Then you can use this with the start and end date based on a date selection for the required month.

'J

CR8.5 / CRXI - Discovering the impossible

 

[jhowardcarter]

awesome .. thanks