Desperate for an answer
 

At work, I've been trying to put our timesheets in a spreadsheet form that
follows the actual old timesheets.
This is a 27 day cycle is lists the employee name, employee number, their
position, and days worked (24 hr. shifts - I'm a fireman).
Within the cells are the two digit date (day - can only use two) and under
each of these dates we enter our time working or days off.
What I've been trying to figure out is a way that compares the actual date
with a named list (Vacation), and places a number in a cell, so it can be
added the already existing days that are in another cell. ex:

If today were the 31st day of March (38807) and I accrued 5 Vacation days
today, it places a 5 in a cell, so i can add it to my existing days of 22 for
my total of 27. I use an array formula that performs the comparisons of the
cycle to the Vacation, and don't know of a way to do it on the actual date.
{=SUM(COUNTIF(Vacation,H12:AH12))*5}. All dates are in ms date format as a
number)

Help would be really appreciated (Before I finish pulling all my hair out).