I am trying to create a payslip calculator. I need to know the total working days for the month. Is there a way to find the working day between the start date and end date glide table?

yes, in Google Sheets formulas, not in Glide

[image] Date Range Exclude Sunday AND 1/2 Saturday Ask for Help Okay, take a look at the below: To get what you need, you’ll need to modify it slightly. The main change will be with the if-then-else (isWorkingDay) column. Instead of returning true, it will ne…

@Jeff_Hager Hi Jeff, really interesting way to solve the problem. Just one more question is there a way to add the date of the next six months automatically in the Glide table? In google Sheets, it’s just dragging to add a date. Not sure how we can achieve this in the Glide table.

[image] Sanam_Shrestha: Just one more question is there a way to add the date of the next six months automatically in the Glide table? [image] If then else with DATE @Darren_Murphy @Milan_Balogh Geez, I had to put on my thinking cap before my morning coffee. The s…

Working Day formula between two date

Ask for Help

Darren_Murphy December 27, 2022, 7:58am 5

Topic		Replies	Views
Excel formula Workdays Ask for Help	3	898	July 13, 2023
Trying to add number or subtract number of days from given date, cant Ask for Help	11	122	June 28, 2025
Identify the fortnight to which the row belongs Ask for Help	8	376	May 6, 2023
Google Sheet formula to apply on Glide Ask for Help	20	617	August 30, 2022
Date difference excluding weekends and bankholidays Ask for Help	10	1123	January 20, 2023

Working Day formula between two date

Related topics