I need help to count all the dates in one column that fall in a specific month and year. I have a summary table that needs to count the occurances for each month of the year.
Dec Jan Feb
CX Complete (F) 0 0 49 32
The source data is in a separate tab under 1 column (S)
Siterra - Forecast
1/21/2013
1/21/2013
3/26/2012
2/10/2012
1/30/2012
3/23/2012
=COUNTIF('SF NetVis PostNTP'!$S:$S,
Is what I started with but can't figure out the rest....
thanks
Hitman
Bookmarks