Spreadsheet: 270016d1381346025-if-month-in-this-cell-is-in-current-month-count-this-other-cell-sample
Sheet: HR

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INT((MONTH(#REF!)-1)/3)+1
 | All Sessions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(MONTH(F24)=MONTH(B1),"Yes","No")
 | Session | Owner | Total Sessions |  |  | Total Registered |  |  |  |  | Total Attended |  |  |  |  | % Attended |  |  |  |  | Survey Results
 |  |  | MTD | QTD | YTD | MTD | QTD |  | YTD |  | MTD | QTD |  | YTD |  | MTD | QTD |  | YTD |  | MTD | QTD |  | YTD |  |  | COUNTIF(F22:F26,">="&DATE(YEAR($B$1),MONTH($B$1),1))-
 |  | Alyssa |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COUNTIF(F22:F26,">="&DATE(YEAR($B$1),MONTH($B$1),1))-     COUNTIF(I22:M26,"F22:F26>="&DATE(YEAR(B1),MONTH(B1)+1,1))
 |  | Alyssa
 |  | [NAME]
 |  | Dave/Stephanie
 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/search.php?searchid=1880985
 | Totals
 | If the date in Column F for Class Type 1 below is in the current month, then count the number of sessions in column K (as I'm looking for the # of sessions Month to Date).  If not, don't count that session(s).  For example, the MTD total (cell [NAME]) should show as 2 since there were 2 sessions held during the 10/01 session.
 | The 1/22 and the 9/24 sessions shouldn't count.  I then need to do the same thing in the QTD (Qtr to Date) cell (K28).  Once I can figure out this formula, then I can apply to the other MTD/QTD cells across row 28.
 | Class Type 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | # value of column U |  | Qtr Conversion Option 2
 | Session | Owner | Presenter(s) | Business | Date | Quarter | Population | # of Sessions |  |  |  |  | # Registered |  |  |  |  | # Attended |  |  |  |  | % Attended |  |  |  |  | Survey Results
 | Cincinnati | Alyssa | Names | H&B | 2013-01-22 00:00:00 | 1 | HR | 1
 | Louisville | Alyssa | Names | Aviation | 2013-09-24 00:00:00 | 3 | HR | 1
 | [NAME] | Alyssa | Names | Regional | 2013-10-01 00:00:00 | 3 | HR | 2
 | Totals (MTD/QTD/YTD)
 | Class Type 2
 | Session | Owner | Presenter(s) | Business | Date | Quarter | Population | # of Sessions |  |  |  |  | # Registered |  |  |  |  | # Attended |  |  |  |  | % Attended |  |  |  |  | Survey Results
 | Totals (MTD/QTD/YTD)
 | Class Type 3
 | Session | Owner | Presenter(s) | Business | Date | Quarter | Population | # of Sessions |  |  |  |  | # Registered |  |  |  |  | # Attended |  |  |  |  | % Attended |  |  |  |  | Survey Results
 | S&SP | [NAME] | [NAME] | All | 2013-01-05 00:00:00 |  | HR | 1
 | Crotonville
 | Totals (MTD/QTD/YTD)
 | Class Type 4
 | Session | Owner | Presenter(s) | Business | Date | Quarter | Population | # of Sessions |  |  |  |  | # Registered |  |  |  |  | # Attended |  |  |  |  | % Attended |  |  |  |  | Survey Results
 | Totals (MTD/QTD/YTD)
 | Class Type 5
 | Session | Owner | Presenter(s) | Business | Date | Quarter | Population | # of Sessions |  |  |  |  | # Registered |  |  |  |  | # Attended |  |  |  |  | % Attended |  |  |  |  | Survey Results
 |  | Debbie L
 |  | Debbie L
 |  | Debbie L
 |  | Debbie L
 | Totals (MTD/QTD/YTD)