How to check if a date is between 2 date fields

[Jean_Pierre_Traets]

Dear @Mohamed_Hamad1 ,

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

Count specific weekdays between two dates / date range

Hi @Vytenis ! I might have a little something for you there for both your questions Using this post as a base : Calculate all months in a range (20x faster) , I ended up with this formula to count Sundays (weekday n°1) in a date range : (for some ease, I created a field Today in my test doc, but the formula works with Today() too and as CountIf() is a slow formula which can lead to performance problem, I didn’t use it ) Sequence(thisRow.[Date X],th…

Credit to @Pch