I have a statutory vacation dates table. and I also have a vacations/leave calendar table. I’d like to know if there is a way to check if a statutory day is in the Start/end date of the vacations/leave calendar. example: Statutory Day - New Years : Jan 1st 2021 Vacation Request: December 28th 20…

FYI here’s the most optimal solution for finding date overlaps: [image] Checking for date overlaps — the most optimal formula Tips and Hacks TL;DR: Room.Bookings.Filter( CurrentValue.End > Search.Start AND CurrentValue.Start < Search.End ).IsBlank() A popular requ…

Dear @Mohamed_Hamad1 , I have the feeling that this post is the direction to go [image] Count specific weekdays between two dates / date range Hi @Vytenis slight_smile ! I might have a little something for you there for both your questions slight_smile Using this post…

You can use NetWorkingDays() formula for calculating vacation days. [image] Coda | Formula library A.k.a. the official book of Coda spells. Our formula library is a comprehensive list of everything cool that comes after "=" in Coda. If there is the table ‘Statuto…

This is a pretty old post but I think I would add a solution. You can sequence() the start and end dates and look to see if a particular date lives between it e.g. Sequence(VacationStarteDate, VacationEndDate).contains(NewYearsDate)

How to check if a date is between 2 date fields

Jean_Pierre_Traets February 21, 2021, 8:13pm 2

Dear @Mohamed_Hamad1 ,

I have the feeling that this post is the direction to go

Credit to @Pch

Topic		Replies	Views
How can I get list of dates between two dates	3	1031	September 20, 2023
Calculate # of weekdays between two dates?	1	476	June 21, 2022
Networking Days - Include ALL days (not just week days)	1	825	April 16, 2020
Number of nights between two dates	4	1303	May 23, 2019
Calculate number of days between two dates without weekends and public holidays	1	403	May 30, 2024

How to check if a date is between 2 date fields

Related topics