Need to determine how many days an employee has used for vacation on a calendar

[kelleyjs]

I have a vacation calendar for over 100 employees. I need to track how many days they use on the calendar, so I know what is scheduled, what is used and what is left. Across the top of the table I have all the dates of the year. On the left the employees names. I was trying to use the hlookup function with the today function to find todays date across the top. That works, but returns todays date. I need to find the date, then drop down to the employees names and start from the beginning of the calendar to today's date counting the days marked with a "V" (for vacation).

A6: Employee number
B6: Last Name
C6: First Name
D6: Hours Available
E6: Hours Scheduled
F6: Hours Used
H6: Starts the calendar from May 1st until April 31st 2015. If the employee schedules a day it's marked with a V. I need a running total that will count from the first day of May until (TODAY()) how many V's there are.

 

[AlphaFrog]

This will count the "v"s in row 7 from H7 to today's date.
Put this in G7 and copy it down column G for each employee.

=COUNTIF(OFFSET($H7,0,0,1,TODAY()-$H$6+1),"v")

 

[kelleyjs]

Awesome. Thanks. I was trying to make it way to complicated using offset, hlookup, and address..........Needless to say way to complicated. Thank you.

 

[AlphaFrog]

You're welcome and thanks for the feedback.