Number of Saturdays between given two dates

[Rahul_Sanghavi]

I need a formula to calculate number of saturdays between two dates.

Please advise.

[AleksiAlkio · Accepted solution]

There are many ways to count it. But if you think through the logic, you could write it like..
HOUR(
EOWEEK([EndDate])-EOWEEK([StartDate])
)
/24
/7
+
IFS(WEEKDAY([EndDate)=7,1)

[Rahul_Sanghavi]

Thanks @AleksiAlkio . This works.

[AleksiAlkio]

Good to hear!