In column B2:B157 I have dates
In column C2:C157 I have =CHOOSE(WEEKDAY(B3),"Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun"), to give me the day, B3 is a specific date
What I want to do in another worksheet is count number of mon, tues, wed,... in a given month.
So the result should tell me 5 reports made on Mon in June, etc.....
Can you please help?
In column C2:C157 I have =CHOOSE(WEEKDAY(B3),"Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun"), to give me the day, B3 is a specific date
What I want to do in another worksheet is count number of mon, tues, wed,... in a given month.
So the result should tell me 5 reports made on Mon in June, etc.....
Can you please help?