Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (12)

Sign In or Sign Up now to post a comment!

  • we can change the formula and put it like bellow to make the holiday column expandable =NOT(NETWORKDAYS(A19,A19,E$19­­­:E19))

    caribeiro77 1 year ago

  • Cool!

    ExcelIsFun 1 year ago

  • Comment removed

    caribeiro77 1 year ago

  • Comment removed

    caribeiro77 1 year ago

  • Comment removed

    caribeiro77 1 year ago

  • Just tried =NOT(NETWORKDAYS formula, works great. Streamlined. I always forget about the NOT. Pretty useful sometimes.

    krn14242 2 years ago

  • Yes, totally streamlined!! I will actually have to make another video to show pererachaminda cool formula!

    ExcelIsFun 2 years ago

  • Comment removed

    pererachaminda 2 years ago

  • you may have already covered this somewhere else. I think we could do the same thing using the "NETWORKDAYS" function.

    =NOT(NETWORKDAYS(A19,A19,$E$19­:$E$20))

    thanks

    pererachaminda 2 years ago

  • That is so much cleverer than the formula I used!

    As I always say, I am not a smart guy with Excel, just a guy having fun with Excel!

    I will make a video about your more efficient formula soon!

    ExcelIsFun 2 years ago

Loading...
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more