# Vacation Taken vs Vacation Scheduled

#### Gtrtim112

##### New Member
I had this post on another 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.

My previous 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'm keeping my fingers crossed!

I don't see a way to attch example sheets here, though. Am I missing something? The spreadsheet is way too large to try to post within this message box.

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### RonB1111

##### Well-known Member

The function COUNTIFS() is a probable solution. If you type in a few rows/columns here, someone will be able to give you the exact formula.

#### Gtrtim112

##### New Member

The function COUNTIFS() is a probable solution. If you type in a few rows/columns here, someone will be able to give you the exact formula.

My spreadsheet columns go all the way to BU and the rows go all the way down to 283... not sure how to post a small example. You'd have to see it to understand what I'm talking about, I guess.

I'll try another board... thanks, though.

#### RonB1111

##### Well-known Member
You could show the 1st 4 rows and the unique columns, the remaining repetitive columns can be verbally described in words - eg: Col E is a date and Cols F-BU are sequential date fields.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,626
Messages
5,838,429
Members
430,547
Latest member
jopshio

### 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