Forum Discussion
Gumzz212
Aug 31, 2023Copper Contributor
IF Statement with Networkdays
I'm trying to calculate workdays between two dates, but can we make it not to count starting date
Example:
I'm trying to count the day between 22/08/2023 - 23/08/2023 but the result always 2 days because the starting date is counted
how to make the starting date is not counted?
=LET(hpos, SEARCH("hr.", C2), hours, IF(ISNUMBER(hpos), LEFT(C2, hpos-1), 0), mpos, SEARCH("min", C2), minutes, IF(ISNUMBER(mpos), MID(C2, mpos-2, 2), 0), 60*hours+minutes)
10 Replies
Sort By
- Riny_van_EekelenPlatinum Contributor
- Gumzz212Copper Contributorhey could you help me, i try to use the -1 but when the progress start and end at the same day it always resulted -1
- PeterBartholomew1Silver Contributor
To exclude the first day from the count, I would go for Riny_van_Eekelen 's first formula
= NETWORKDAYS(initialDate+1, finalDate)