[ =SUMPRODUCT((TEXT($B$14:$B$1113,"ddd;;;")="Jan")+0) ]
This formula was originally written to count the instences of days of the week.
I need to revise it to count the instences of months.
In this data, April should return 5, and May should return 4.
Can anyone help with this?
Thank in advance, Sick
Tuesday, April 24, 2012
Tuesday, April 24, 2012
Wednesday, April 25, 2012
Thursday, April 26, 2012
Monday, April 30, 2012
Friday, May 11, 2012
Wednesday, May 02, 2012
Wednesday, May 02, 2012
Wednesday, May 02, 2012
Bookmarks