Forum Discussion
Gumzz212
Oct 25, 2023Copper Contributor
The difference between 2 days
I'm trying to count the difference between 2 days, but excluded weekends I try with function networkdays but it always count the starting date. When I add -1 to the function, it start to count the p...
Gumzz212
Oct 25, 2023Copper Contributor
May I tell you what i want?
There is a fixed date that cannot be changed, I want this date to be a benchmark for the next date
The next date is a date that can change, it would be better if it was filled in before the fixed date but it's okay if it was filled in after the fixed date but don't take too long
As example
The fixed date/deadline was: 18 oct 2023
The change date : either before 18 oct 2023 or after
If it filled at 17 oct 2023 the count is -1
if it filled at 18 oct 2023 the count is 0
if it filled at 19 oct 2023 the count is 1
of course the count is excluding weekend
appreciate if you can help me
There is a fixed date that cannot be changed, I want this date to be a benchmark for the next date
The next date is a date that can change, it would be better if it was filled in before the fixed date but it's okay if it was filled in after the fixed date but don't take too long
As example
The fixed date/deadline was: 18 oct 2023
The change date : either before 18 oct 2023 or after
If it filled at 17 oct 2023 the count is -1
if it filled at 18 oct 2023 the count is 0
if it filled at 19 oct 2023 the count is 1
of course the count is excluding weekend
appreciate if you can help me
HansVogelaar
Oct 25, 2023MVP
Please avoid asking the same question multiple times - it causes unnecessary duplication of work.
- Gumzz212Oct 25, 2023Copper Contributorokay thanks for your suggestion
will not doing it again