Count Formula based on Date

Need some help,

I need to count the number of cells (in a column) that has a certain word in it based on the date in another cell (the date is formatted 1/4/2019)
 

So i have a column with Direct, Strategic, Master (called it Column D)
 

another column has dates (formated 1/4/2019) in Column H
 

I wanted to count the number of times Direct shows up for the month of January

This is what it would look like (for example)

<!–table {mso-displayed-decimal-separator:”.”; mso-displayed-thousand-separator:”,”;} @page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;} tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl65 {mso-number-format:”Short Date”;} –>



Partner Date
Master 1/4/19
Direct 2/7/19
Engaged 3/10/19
Engaged 1/4/19
Engaged 2/7/19
Engaged 3/10/19
Master 1/4/19
Master 2/7/19
Direct 3/10/19
Master 1/4/19
Direct 2/7/19
Direct 3/10/19

 

 

By: Delvin Johnston

554 thoughts on “Count Formula based on Date

Comments are closed.