Share via

How To Calculate Days Hours And Minutes Between Two Dates In Excel while also excluding weekends?

Anonymous
2018-02-27T23:47:01+00:00

Hello, I'm hoping somebody can help!  I am trying to calculate the difference between 2 dates & times in excel which also excludes weekends (saturday & sunday).  I've managed to find the formula which will neatly calculate the days/hours/minutes but this formula does not exclude weekends.  Does anybody know how to take this formula one step further to exclude weekends between the two dates?  Thank you!!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Ashish Mathur 101K Reputation points Volunteer Moderator
    2018-02-28T00:03:41+00:00

    Hi,

    Replace the INT(B2-A2) portion of your formula with

    NETWORKDAYS(INT(A2),INT(B2))

    Does this help?

    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-02-27T23:51:01+00:00
    0 comments
  2. Anonymous
    2018-02-27T23:54:38+00:00

    like all formulas, networkdays already has a preset structure and doesn't work with the formula that I'm already using.  This is why I'm asking for help.

    0 comments
  3. Anonymous
    2018-02-28T15:49:01+00:00

    Hi Ashish, this did not work.

    0 comments
  4. Anonymous
    2018-02-28T19:16:31+00:00

    Ashish, looks like it was my error.  Your suggestion worked!!  Thank you!!

    0 comments