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	1051	January 20, 2023
Date in If Else Column Subtraction Ask for Help	34	603	September 23, 2021
Calculation of days excluding weekends Ask for Help	12	1851	February 13, 2024
Hyperformula - WORKDAY.INTL Ask for Help	6	450	November 9, 2021
Duration between 2 dates: days, months, years Ask for Help	15	1310	December 1, 2022

Networkdays excel formula

Related topics