Countifs by date and by cell value

[cjjn]

hello

I am trying to count vacation days booked vs taken

i have each date as acolumn header

1/1/14 1/2/14
Emp 1 1
Emp 2 2

I only want it to count if it is a 2 and if it is prior to 'today'

any ideas?
Thanks!

 

[Momentman]

I really can't make much of the table. Could you give more ample data and what your desired output should be?

 

[cjjn]

I really can't make much of the table. Could you give more ample data and what your desired output should be?

Sorry

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.
Row 2Emp1
Row 3emp2
Row 4emp3

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

Thanks