+ Reply to Thread
Results 1 to 3 of 3

Difference in NETWORKDAYS, but to current date if cell is empty

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    Materion
    MS-Off Ver
    Excel 2010
    Posts
    13

    Difference in NETWORKDAYS, but to current date if cell is empty

    My spreadsheet has columns for 2 dates (date requested, date issued) and I have another column that counts the number of days in between. Right now, the formula is =NETWORKDAYS(A254,E254)-1

    My problem is if the date of issue column is blank, it displays a large negative number.

    What I'd like to do is, if the issue column is blank, have it display the number of days from the date of request to the current date.

    Thank you

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Difference in NETWORKDAYS, but to current date if cell is empty

    Try

    Please Login or Register  to view this content.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    02-22-2013
    Location
    Materion
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Difference in NETWORKDAYS, but to current date if cell is empty

    Amazing! You are a lifesaver! Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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