Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    125
    Thanked 5 Times in 5 Posts

    Calculating 21 working days bewteen two dates

    I have used networkdays to capture the days between two dates less 21 days as the interest is only to be computed 21 business days after the start date, excluding public holidays


    I have attached my workbook and would like someone to kindly check if it is correct. If it is not I would like this amended
    Attached Files Attached Files
    Last edited by HowardC; 2016-04-19 at 05:50.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 651 Times in 593 Posts
    Howard,

    Try in cell D2:
    =NETWORKDAYS(WORKDAY(B2,21,P2:P4),C2,P2:P4)
    =34

    This will give you the number of workdays starting after the 21st workday after B2 to the end date C2.

    HTH,
    Maud

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    HowardC (2016-04-19)

  4. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    125
    Thanked 5 Times in 5 Posts
    Thanks for the help Maud, much appreciated

Posting Permissions

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