Date Calculation

[jedilefty]

Hello! How can I calculate the number of working days between two dates, and the start date would count as 0? If something started on 12/2/24 and completed on 12/5/24 result should be 3 days, not 4.

Currently using the formula:

=NETWORKDAYS(start_date,completion_date)-SIGN(NETWORKDAYS(start_date,completion_date,))

 

[Jeffrey Mahoney]

=NETWORKDAYS(start_date,completion_date)-1


That is funny that NETWORKDAYS calcs the first day as part of the equation. Official Description:
Returns the number of whole working days between start_date and end_date.

 

[jedilefty]

=NETWORKDAYS(start_date,completion_date)-1


That is funny that NETWORKDAYS calcs the first day as part of the equation. Official Description:
Returns the number of whole working days between start_date and end_date.

Thank you for the reply Jeffrey. However, I found out what the problem was. I also had holidays excluded and I referenced the wrong cells with those holiday.