Hi, I am trying to calculate date difference from StartDate to EndDate, and I found interesting excel command from @gvalero : Date difference excluding weekends and bankholidays When I test it, I can use: NETWORKDAYS(A1, A2, {“10/2/2024”, “11/1/2024”, “11/12/2024”, “11/25/2024”, “12/24/2024”, “12…

I didn’t understand what Yasin meant LOL But I manage to solve this issue by using template as the excel formula [Screenshot 2024-07-19 at 14.49.07] [Screenshot 2024-07-19 at 14.49.22] [Screenshot 2024-07-19 at 14.49.39]

Networkdays excel formula

Ask for Help

ThinhDinh July 17, 2024, 1:31pm 3

I just re-embedded the video that @Darren_Murphy had in that thread.

2 Likes

Topic		Replies	Views
Date difference excluding weekends and bankholidays Ask for Help	10	1082	January 20, 2023
Calculation of days excluding weekends Ask for Help	12	2080	February 13, 2024
Trying to add number or subtract number of days from given date, cant Ask for Help	11	63	June 28, 2025
Working Day formula between two date Ask for Help	4	685	December 27, 2022
Hyperformula - WORKDAY.INTL Ask for Help	6	460	November 9, 2021

Networkdays excel formula

Related topics