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

Networkdays excel formula

Related topics