Vacation Days Taken vs Vacation Days Scheduled

I had this post on the formula board and someone suggested that I give this board a try. I'm trying to make this spreadsheet figure an employees vacation that has been taken (according to the current days date) vs what that same employee has scheduled for tomorrow through the rest of the year.

Lemice (my helper) was able to get it to figure scheduled vs taken but only to the current month. For example, if someone had vacation scheduled for tomorrow, April 30th. It would show as "Taken" even though that day hasn't happened yet, as it is only the 29th. He suggested a helper column of some sort but I'm not sure what to do to get it to work. I'm hoping someone here will have a brilliant idea

I've attached an example for you to see. *Note - The days/dates on the calendar change columns depending on what year is selected on the "Year Calendar" tab.

I'm keeping my fingers crossed!

Originally Posted by dilipandey

Hi Gtrtim,

your comment in yellow arrows says " This figure should be 4 (For the 4 hours of V taken through today's date)" and I want to know how you arrived at 4hrs ?

Regards,
DILIPandey
<click on below * if this helps>

It would be for the 4 hours (Showing as V4 in January) that Employee 1 took already. Someone has already figured this out for me, though. Thanks for the reply