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!
Bookmarks