Friends, I am looking for a excel formula which would calculate the count of M in each row by checking the weekdays row for Sat and Sun.
Like in my spreadsheet attached, on the Row 3 i have only 1 M showing under Sat and Sun, so the result should be 1. And similarly in the next row i have 3 M for Sat and Sun, hence the result is showing as 3.
Pls let me know if my question is not clear.. Thank you in advance.