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

#### kelleyjs

##### New Member
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.

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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")

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

You're welcome and thanks for the feedback.

Replies
0
Views
411
Replies
0
Views
285
Replies
3
Views
390
Replies
3
Views
916
Replies
4
Views
614

1,196,048
Messages
6,013,088
Members
441,747
Latest member
darkman77

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back