I really can't make much of the table. Could you give more ample data and what your desired output should be?
vacation code =2 (could also be a 1 for sick day, 3 for unpaid day etc.)
i want to count # of vacation days taken (per employee) and number of vacation days booked (per employee)
Right now I have each employee in their own row
Columns B through MR represent each day of the year
In column MS the header row is labeled Vacation days taken - for row 2 as an example I need this to be count if B1 - MR1 less than or = to today AND Row 2 = 2
In column MT the header row is labeled Vacation days booked - for row 2 as an example I need this to be count if B1 - MR1 = greater than today AND Row 2 = 2
Row 1 1/1/14 1/2/14 1/3/14 etc.
I dont know how to make it look at both the date in Row 1 and the cell value in row 2 to count it either as booked or taken.
Hope that was more clear - sorry I dont think i am doing a great job explaining myself