261 days a year

[damhuet]

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.

[arthurbr]

Hi and welcome to the board.
Do you want to extract only working days or all days except week-ends ( holidays included)?

[damhuet]

Hi,
thank you for your answer. I would like to extract all days except week ends (Including holidays).
Thanks
D.

[sglife]

I think this is what you need

Please Login or Register  to view this content.

Then copy down

[damhuet]

Thanks a lot, I will try it and let you know.
D.

[damhuet]

Please note the formula above works well to extract only weekdays.
Thanks
D.