Forum Discussion
Solved
How can I Calculate to amount on Mondays in my header but only the mondays in my headers?
I have headers B1:GY1 that are dated but it is not constant days in a row, it is a school schedule & I need to count the amount of Mondays, Tuesdays, etc. up to today's date when today's date is loca...
For Mondays:
=SUMPRODUCT((B1:GY1<=TODAY())*(WEEKDAY(B1:GY1)=2))
The number 2 near the end of the formula is the day of the week:
1=Sunday
2=Monday
3=Tuesday
...
7=Saturday
For Mondays:
=SUMPRODUCT((B1:GY1<=TODAY())*(WEEKDAY(B1:GY1)=2))
The number 2 near the end of the formula is the day of the week:
1=Sunday
2=Monday
3=Tuesday
...
7=Saturday
Thank you so much, I will put it to work tomorrow & let you know how it works.