Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2007
    Location
    United States
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    WORKDAY Formula Array (2003)

    In the attached workbook I have two worksheets. Worksheet Sheet2 is merely a table used for a VLOOKUP formula that was developed in a previous post.

    In Column D of the Master worksheet, I am trying to calculate a date that is exactly 15 business days (don't count weekends or holidays A2:A11) after the value of Column B. I have used the formula array: =(B14+21)+VLOOKUP((B14+21),Sheet2!$A$1:$C$365,3,0) , but I need to change the number "21" in the array with some kind of WORKDAY variable that would account for the holidays in A2:A11.

    Column E is just a quality control check of Column D. All values should calculate to 16.

    Would I need to modify the table on Sheet2 to accommodate this and reference it somehow?

    Any help is greatly appreciated.

    Thanks
    Amy
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: WORKDAY Formula Array (2003)

    Create a table with only the holidays, for example in Sheet2!G1:G10 (G1 is 10/13/08, G2 is 11/11/08 etc.)
    You can then use =WORKDAY(B14,15,Sheet2!$G$1:$G$10) in D14 and fill down.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2007
    Location
    United States
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: WORKDAY Formula Array (2003)

    Thanks, Hans. That was spot on.

    Amy

Posting Permissions

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