Hello dears, I need to make a calculation to count the training duration excluding the weekend (Friday & Saturday), which will be used in the Training database
I have tried this formula but stuck here: NETWORKDAYS.INTL([Start Date], [End Date],)
Any support will be much appreciated.
Hello Amotasem,
I don’t think there is such a function in ActivitiInfo — NETWORKDAYS.INTL is from Excel/Google Sheets.
Still, we can count the number you need.
FLOOR(DAYS([Start Date], DATE(2025, 1, 3)) / 7)
and the number of Fridays before [End Date] is
FLOOR(DAYS([End Date], DATE(2025, 1, 3)) / 7)
Their difference gives the number of Fridays between [Start Date] and [End Date].
2. We do the same for Saturdays, using 2025-01-04 as the reference date.
3. Finally, the total number of working days (excluding Fridays and Saturdays) between [Start Date] and [End Date] is:
DAYS([End Date], [Start Date])
- (FLOOR(DAYS([End Date], DATE(2025, 1, 3)) / 7) - FLOOR(DAYS([Start Date], DATE(2025, 1, 3)) / 7))
- (FLOOR(DAYS([End Date], DATE(2025, 1, 4)) / 7) - FLOOR(DAYS([Start Date], DATE(2025, 1, 4)) / 7))
Best regards,
Mitya
Hello Mitya,
Thanks a lot for your hard work. It somehow works, but I faced another issue. If I chosed the start date is 10-08-2025 and end date is 17-08-2025, it will count only 5 days, where it should be 6 days.
I have attached the picture for your reference
Yes, you are right — it counts the days between the dates, so if you use the same date for both start and end, you’ll get zero.
Try replacing every [Start Date] with ADDDATE([Start Date], -1)
I believe this will work:
DAYS([End Date], ADDDATE([Start Date], -1))
- (FLOOR(DAYS([End Date], DATE(2025, 1, 3)) / 7) - FLOOR(DAYS(ADDDATE([Start Date], -1), DATE(2025, 1, 3)) / 7))
- (FLOOR(DAYS([End Date], DATE(2025, 1, 4)) / 7) - FLOOR(DAYS(ADDDATE([Start Date], -1), DATE(2025, 1, 4)) / 7))
It works, thanks dear.