Given two dates, calculate the number of weekend days between them (saturdays/sundays)

[BS_THE_ANALYST]

Hi all!

I was just working on Weekly Challenge 41 when I was inspired by this particular problem. 

Can we write a formula where we input two dates, and it will output the number of weekend days in between them? (inclusive of both dates)

For example: given these two dates -  Wednesday 28th December 2022 & Saturday 14th January 2023. We can see, by manually counting, that there are 5 weekend days between them.

I'd love to see some different takes on tackling this question! 

Thanks, 

BS

[Inactive User]

Cool approach @DataNath thanks for sharing