Hello We are trying to set uo a leave request app. As it goes, we are unable to exclude week-ends and bank holidays. (date2 - date1) We have tried through an Excel formula that does this, but it does not work in the glide table, so we tried Javascript but here again the code does not run… Is the…

oh, my… did you really use all that JavaScript in preference to the solution that I gave you? Totally your choice of course. But gee whiz, just looking at that makes my head spin. Good luck maintaining that, and debugging it when it breaks :wink: Anyway, I’ll see if I can take a look at your app l…

Is the goal to calculate the number of days leave between a given start and end date, excluding weekends and public holidays? You can use a couple of helper tables with a bit of Glide Date math to do that. If you confirm that is the goal, I can show you how to do it.

Hola, Glide’s Excel plugin has a function that can help you: NETWORKDAYS(Date1, Date2[, Holidays]) Saludos!

Thank You Darren. It worked well. Learned a lot.

[image] gvalero: Glide’s Excel plugin has a function that can help you: NETWORKDAYS(Date1, Date2[, Holidays]) I will give it a try. Thank you.

Hi Darren, We finally used javascript to sort it out. let startDate = new Date(p1); let endDate = new Date(p2); endDate = new Date(endDate.getTime()+360010002); let currentDate = new Date(startDate.getTime()+360010002); let dayCount=0; let an = currentDate.getFullYear(); let JourAn = new Dat…

Date difference excluding weekends and bankholidays

Ask for Help

Darren_Murphy December 4, 2022, 9:37am 3

@Lise_Delarue - here…

Automatic subscription date calculation : every week, every 2 week, every month

Networkdays excel formula

Topic		Replies	Views
Calculation of days excluding weekends Ask for Help	12	2690	February 13, 2024
Networkdays excel formula Ask for Help	8	156	July 19, 2024
Trying to add number or subtract number of days from given date, cant Ask for Help	11	145	June 28, 2025
Working Day formula between two date Ask for Help	4	739	December 27, 2022
Javascript to calculate Work days Ask for Help	5	1652	July 13, 2023

Date difference excluding weekends and bankholidays

Related topics