+ Reply to Thread
Results 1 to 8 of 8

Trying to count holiday taken so far

Hybrid View

  1. #1
    Registered User
    Join Date
    09-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Trying to count holiday taken so far

    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!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-23-2014
    Location
    Dubbo, Australia
    MS-Off Ver
    EXCEL 2019
    Posts
    180

    Re: Trying to count holiday taken so far

    Here is an example of how to get it working... you can drag the lowermost cell across the columns to add up for more employees
    Attached Files Attached Files
    Last edited by dubcap01; 06-24-2014 at 05:39 AM.

  3. #3
    Forum Contributor
    Join Date
    06-23-2014
    Location
    Dubbo, Australia
    MS-Off Ver
    EXCEL 2019
    Posts
    180

    Re: Trying to count holiday taken so far

    a more upbeat version...
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 11-08-2013, 05:01 AM
  2. [SOLVED] IF function using WORKDAYS and a Bank Holiday list - trying to add new holiday dates
    By jowarks in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-05-2013, 05:42 AM
  3. Replies: 5
    Last Post: 07-02-2010, 06:39 PM
  4. Holiday Planner show holiday taken?
    By Mac5 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2006, 01:23 PM
  5. Holiday Pay
    By johnrann in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-17-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1