I am trying to count the number of particular Weekdays between two dates. For example I want to know how many Sundays there were between DayX and Today().
I tried to use a formula like this: Countif(Weekday(Sequence([DayX],Today())),CurrentValue=1). However, looks like Weekday formula does not operate on a list, only on a specific date input. Do you have any suggestions how to run this so it works?
Bonus question: what equation would be if I wanted to count multiple types of weekdays (for example both Saturdays and Sundays). I think it should be Countif(Weekday(Sequence([DayX],Today())),CurrentValue=List(7,1)) but not sure about that since I cannot get Weekday formula to work on a list.