Excel: How to return the total number of values in a table column based on date

I have a spreadsheet is meant to track employee vacation days.  The leftmost Column contains employee names, and the Column Headers contains dates for the current scheduling period.   I need to be ...