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


  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    Is this a duplicate of this thread?

Posting Permissions

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