Oh so I have a table with Years down one side and months along the top
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2006
2007
2008
2009
2010
2011
2012
2013
2014
Then a range of 400 different dates, and basically I want a count formula that will count number of those dates that are in Jan 2006, Feb 2006 etc
Am Trying something with sumproduct or countifs and year/month functions but cant quite get it to work.
Anyone got a quick solution, have also tried pivottable but again cant quite get it.
Thanks
Bookmarks