Results 1 to 3 of 3

Thread: NETWORKDAYS With Blank Cells

  1. #1

    NETWORKDAYS With Blank Cells



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

    Need help:
    I have 4 different dates in 4 cells and I want to apply IF condition with networkdays that if 1st cell is empty takes the second and calculates networkdays if second and also empty calculates with third one. I apply the formula =IF(AW5="",NETWORKDAYS(AT5,AV5),IF(AV5="",NETWORKDAYS(AT5,AU5),NETWORKDAYS(AT5,AU5))) but the issue is that its giving me negative days because 1st 2 cells are empty and its not fulfilling the condition. Please help

  2. #2
    DO you mean

    =IF(OR(AW5="",AV5=""),NETWORKDAYS(AT5,AV5),IF(OR(AV5="",AU5=""),NETWORKDAYS(AT5,AU5),NETWORKDAYS(AT5,AU5)))

  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,372
    Articles
    0
    Is this a duplicate of this thread?

    https://www.excelguru.ca/forums/show...elp-in-formula


Posting Permissions

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