Trying to count holiday taken so far

**Merboo** · 06-24-2014, 04:56 AM

Hi Everyone,

My manager's asked for something slightly awkward. We have a spreadsheet that plans all holidays taken and planned for the year, but now my manager wants a row at the bottom that counts only holiday days taken to date. All holiday days have H in the cell.

The dates are in descending order in column E, then the employees are in the following columns. I was thinking I could use something that involves the =TODAY() formula, and =COUNTIF with a vlookup? Or am I on the wrong track entirely?

**Richard Buttrey** · 06-24-2014, 05:14 AM

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

**Merboo** · 06-24-2014, 05:23 AM

Sorry, here's an example of the workbook.

Currently, nothing is calculated. The H in certain cells means that a holiday was booked for that day. All days before and including today's date with H in the cell are holidays already taken, all days after today's date with H in the cell are holidays planned for the future.

My manager wants a count of all holidays up to and including today's date, which is why I thought the =TODAY() might help along with a =COUNTIF.

Unfortunately my manager does not want the layout to change at all. Please let me know if you need more information!