+ Reply to Thread
Results 1 to 3 of 3

Calculate holiday accrued at current month

  1. #1
    Registered User
    Join Date
    01-24-2011
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    16

    Question Calculate holiday accrued at current month

    Hello all,

    I need some help if possible. I would like to calculate how much holiday leave an employee is entitled to at the present date. I have been playing with SUMPRODUCT but cant seem to find the correct method.

    If say the current date is anytime in a month, I would like all the months previous including the current month added. I know this is simple but...

    Please see the attached spreadsheet for more info.

    Note:
    E4 is where I would like the formula/ data
    Cell S2 has today's date.
    Cells F4:Q4 have the monthly allowance (Yearly total/12)

    Best Regards and thanks in advance,

    Warren
    Attached Files Attached Files
    Last edited by fugro; 02-23-2011 at 06:08 AM. Reason: Solved

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Calculate holiday accrued at current month

    There's probably a better wya to do it, but as a simple fix please see attached.

    Note I've had to include the month numbers in row 3.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-24-2011
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Calculate holiday accrued at current month

    Thanks brokenbiscuits thats done the trick!

    Much appreciated

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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