Results 1 to 9 of 9

How to count network days between two dates, using todays date where second date is blank?

Threaded View

  1. #1
    Registered User
    Join Date
    03-19-2012
    Location
    Leeds, UK
    MS-Off Ver
    Excel 2010
    Posts
    2

    How to count network days between two dates, using todays date where second date is blank?

    Hi

    I am looking to create a formula that will count the number of work days (network days) between two dates and to use today's date where the second is blank.

    The intention is that I can show how old incidents are in the one cell, regardless of whether they are open or closed

    Here's the layout for what i want to achieve:

    Col A, Col B, Col C
    Row 1, Open Date, Closed Date, No.Workdays Open
    Row 2, 05-Mar-2012, 12-Mar-2012, 6
    Row 3, 16-Mar-2012 , *, 2

    *where today is the 19 March


    So far I have worked out how to use Network Days
    =NETWORKDAYS(A2,B2)

    And how to use today's date where col B is blank
    =IF(ISBLANK(B2),TODAY()-A2,B2-A2)

    But I can't seem to combine the two.

    Any suggestions greatly appreciated.
    Last edited by phl8pg; 03-19-2012 at 12:48 PM.

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