Hello, Is it possible to calculate the number of days between two days without counting weekends? I know you can calculate with “date difference” but I can’t find a way to subtract the weekend. Example: The number of days (or minutes) between 05/02/2024 at 05:00 and 22/02/2024 at 05:00. Thank y…

From AI: Sure you can use the Excel formula: =NETWORKDAYS(A1, A2, A4:A10) Assuming you have the start date in cell A1 and the end date in cell A2, and a list of holidays in cells A4 to A10. This formula calculates the number of business days between the dates in A1 and A2, excluding weekends and…

@tuzin has a Math column that does this that will make your head explode. See below: [image] date Guide on Dates & Times Community Resources Thank you for combining all this valuable info into one post! This is also relevant here This math formula adds N business days t…

How can i use this ? In Java script code ? What values do i need to change ?

It would be used in a Math column. However, I’ve just realised that formula doesn’t quite do exactly what you are looking for. It adds a given number of business days to a start date, whereas you want to calculate the number between two dates. So it would need to be modified somewhat. @tuzin is al…

I’m 100% willing to try this a bit later. @FlorianA Please remind me about it if I don’t post in the next 24h :sweat_smile:

Hi Tuzin, Can you really help me ? Or it is a joke ?

That would be a bad joke. I’m really eager to help

Oh great! I’m new to this forum I’ll explain what I need I need to put a start date in a “date entry” and an end date in another “date entry”, and I need to have a list of all the working days in a sort of “join list”. Do you understand? And will you be able to help me?

[image] My setup, tested in Safari, which has been problematic with Date functions in JavaScript in the past. [image] Date Start & End, user-specific columns, Date Pickers write into these columns. Timezone: gotta have this to use in the JS function, since Glide seems to return UTC-based values…

Thank you very much for this answer I will test this as soon as possible

Calculation of days excluding weekends

Ask for Help

Darren_Murphy February 7, 2024, 1:09pm 3

@tuzin has a Math column that does this that will make your head explode. See below:

Topic		Replies	Views
Date difference excluding weekends and bankholidays Ask for Help	9	1148	December 28, 2022
Trying to add number or subtract number of days from given date, cant Ask for Help	11	173	June 28, 2025
Networkdays excel formula Ask for Help	8	180	July 19, 2024
Javascript to calculate Work days Ask for Help	5	1669	July 13, 2023
Available Days Ask for Help	1	205	April 25, 2023

Calculation of days excluding weekends

Related topics