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]

[Screenshot 2024-07-17 at 09.20.21] Here is the Excel formula that I use [Screenshot 2024-07-17 at 09.20.40] Here is the array of holidays that I want to use

I just re-embedded the video that @Darren_Murphy had in that thread. [image] Date difference excluding weekends and bankholidays Ask for Help @Lise_Delarue - here…

Thank you @ThinhDinh for the info the solution needs to create a whole start & end date range record/table … which in the end can calculate the leave period… but in my case, I need to do that for all leave submissions that the employer submitted, so I don’t think it’s possible/scalable for my case …

[image] EDATE in Excel formula is not working Report a Bug So I managed to run formulas in excel by creating a column template and replacing the values in it, mostly the issue was because the I can’t add Double Quotations in the Excel formula like the image below [image] …

one more thing … if someone still has some issues, you may want to check your start & end date format, since if you use the default Glide date format it will use mm/dd/yyyy, hh:mm AM/PM, while networkdays I think only need mm/dd/yyyy (without the time), so I use split & single first [Screenshot 202…

[image] Lee: But I manage to solve this issue by using template as the excel formula Yeah I think that was exactly what Yasin did. [image] Lee: one more thing … if someone still has some issues, you may want to check your start & end date format, since if you use the default Glide date f…

Be careful with that. Date formatting is device specific. What you see in the Glide Builder is just the way that your specific device represents the date and time. Other devices will format the date in different ways. For example, some may use MM/DD/YYYY, and others may use DD/MM/YYYY. Some may use …

Networkdays excel formula

Ask for Help

ThinhDinh July 19, 2024, 1:00am 5

Can you try this workaround? It’s not the same function, but your root problem might be due to the double quotes.

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

Networkdays excel formula

Related topics