+ Reply to Thread
Results 1 to 2 of 2

Workday function

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    RSA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Workday function

    I need help with the Workday function in what seems like a simple problem but I can't think of a solution.

    I have a workday function that uses a trade date and calculates T+3days effectively which must be 3 working days (hence the workday function). I also need it to exclude public holidays... easy enough.
    Where I am having the trouble is that I use the function in multiple places for various trades that could be from 1 of 8 jurisdictions which obviously all have their own public holidays. I therefore have 8 columns in excel with the lists of the public holidays. What I want to do is ensure that my workday function 'extracts' the list of public holidays from the correct column. So if the trade happens in the US it looks up to column 2 which is the US and pulls the list of public holidays into the workday function. I just don't know how to do this cleanly. Embedded ifs don't work as it exceeds the number and I would prefer a cleaner solution. I would think I need some sort of array or something which really isn't my strong suite, please help.

    Thanks

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Workday function

    You can use the INDEX function to return the array for you by placing a zero as the row-number.

    Please Login or Register  to view this content.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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