DateDIF Excluding Weekends (But showing day 0)

[Tingle]

Hi Guys,

Can anyone help me with this formula?

I know I can use either one to exclude weekends however if the Start date is the same as the completed date it shows 1 day where effectively I need it to show 0.

=NETWORKDAYS(A1,B1)

=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7))

Surely it wont be as simple as adding a -1 after?

Any suggestions would be great?

Thanks

Tingle

 

[Jonmo1]

Try

=MAX(NETWORKDAYS(A1+1,B1),0)

 

[barry houdini]

Surely it wont be as simple as adding a -1 after?

It depends on what you know for sure about your dates. If B1 is always >= A1 and they are both working days (Monday to Friday) then subtracting 1 will always work

 

[Jonmo1]

If B1 is always >= A1 and they are both working days (Monday to Friday) then subtracting 1 will always work

I prefer to either Add 1 to the StartDate or Subtract 1 from the End Date.
If either Start or End date happens to be a weekend, then just subtracting 1 from the overal result would be eroneous.

 

[barry houdini]

Hello Jonmo,

I suppose what’s missing here is complete explanation of the required result.

Perhaps it can’t happen in Tingle’s case, but what should the result be if A1 is a Friday and B1 is the following day......or A1 is a Sunday and B1 is the following day?

I’m not advocating subtracting 1 as the best solution, just suggesting when it might be appropriate to use