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 you

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 the holidays listed from A4 to A10.

@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 to a specified date assuming Saturday and Sunday are weekends. This formula will always return a business day and it doesn’t account for public holidays. date+floor(n/5)*7+mod(n,5)-hour(date)/24-minute(date)/1440-second(date)/86400 + 2*(max(weekday(date+floor(n/5)*7+mod(n,5)-hour(date)/24-minute(date)/1440-second(date)/86400)-6,0)) + (max(weekday(date+floor(n/5)*7+mo…

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 always up for a challenge. He might do that if you ask him nicely :wink:

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 in the JS function instead of returning it as is. Say I choose 15th Feb, it returns a Zulu timestamp of 5PM 14th Feb (I’m UTC+7). [image] Working Days JS: JavaScript column. const timezoneOffset = parseInt(p3, 10); const start = new Date(p1); const end = new Date(p2); start.setHours(start.getHours() + timezoneOffset); end.setHours(end.getHours() + timezoneOffset, 59, 59, 999); let currentDate = new Date(start); const workingDays = []; while (currentDate = 1 && currentDate.getDay() <= 5) { workingDays.push(currentDate.toISOString().split('T')[0]); } currentDate.setDate(currentDate.getDate() + 1); } return workingDays.join(', '); p1: Start p2: End p3: Timezone

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	1174	December 28, 2022
Trying to add number or subtract number of days from given date, cant Ask for Help	11	222	June 28, 2025
Networkdays excel formula Ask for Help	8	204	July 19, 2024
Javascript to calculate Work days Ask for Help	5	1689	July 13, 2023
Available Days Ask for Help	1	213	April 25, 2023

Calculation of days excluding weekends

Related topics