I've built a holiday tracker that counts hours taken and calculates remaining
allocations for my staff and for the upcoming holiday year I wanted to add an
additional feature that also tracks what days trhe holiday has been taken on,
but I cant figure out how to collect this information automatically. All the
cells with information in use conditional formatting to change the cell
colour, but I also use dashes to signify a day without hours that still
counts as part of the holiday so I can't use a formula based on cell colour.
What I want is to know how many mondays, tuesdays, wednesdays etc an employee
has taken, so I only need to count the cells with a numberical value in them.

I've put an example in from my tracker below - if anyone can help it would
be greatly appreciated.

P.S. I'm running Excel 2007


5 6 7 8 9 10 11
M T W T F S S
7.50 7.50 7.50 7.50 7.50 - -

7.50 7.50 7.50 7.50 7.50 - -

5.00 5.00

5.50 5.50
- - - - - 5.50 -