Results 1 to 2 of 2

Thread: Calculating days Network days and federal holidays

  1. #1

    Calculating days Network days and federal holidays



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need to determine if the date a form was submitted was on time (within 3 days of the request) but I do not want to penalize them for weekends and Federal holidays. I need to be able to take a date and calculate using that date plus 3 days but not including the weekends or federal holidays. So for example:

    Col. A: Request Date Col. B: Due Date Col. C: Formed Rec'd Col. D: Days Late
    06/30/2011 07/06/11 07/08/11 2

    I need a formula to calculate Col. B (Col. A plus three days not incling weekends and federal holidays) then a formula to calculate Col. D (Col. C - Col. B)

    Please help.

  2. #2
    Try

    =WORKDAY(A2,3,holidays)

    where holidays is a list of those federal days.

Posting Permissions

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