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	1107	January 20, 2023
Calculation of days excluding weekends Ask for Help	12	2198	February 13, 2024
Return TRUE if date range is within date range Ask for Help	4	551	November 5, 2019
Hyperformula - WORKDAY.INTL Ask for Help	6	468	November 9, 2021
Working Day formula between two date Ask for Help	4	709	December 27, 2022

Networkdays excel formula

Related topics