Hi,
I have a historical of 365 days over one year and I would like to extract only the working days of this historical. Basically, between the 1/11/2007 and the 31/10/2008 I would like to see only the weeks with 5 workings days excluding Saturdays and Sundays. Which formula should I use to answer this? Should I use WEEKDAY function and some IF functions or is there any one more efficient?
Thanks for your help
D.