I would be very appreciative of anyone's help on this. Here is what I am trying to do:
I have a column for reporting meeting dates for each entity. So a cell may contain numerous dates. For example:
<tbody>
</tbody>
What I am trying to do is count the total number of meetings that all of my entities had within a certain month.
I imagine I need to use the COUNTIFS formula, but I can't seem to get it to search the cell for a particular value within a list of comma separated dates. Here is the COUNTIFS formula that I am trying to modify to search for a certain date within a cell that contains comma separated dates.
=COUNTIFS(AL$4:AL$323,">6/30/13",AL$4:AL$323,"<8/1/13")
Thank you very much for your help. I have been working on this for a several days and can not figure it out.
I have a column for reporting meeting dates for each entity. So a cell may contain numerous dates. For example:
Entity | Meeting Date |
Entity#1 | 5/1/13, 4/10/13, 11/10/12, 9/14/13 |
Entity#2 | 6/3/13, 7/21/13 |
Entity#3 | 11/10/13 |
Entity#4 | 8/12/13, 8/4/13, 1/2/13, 3/23/13 |
<tbody>
</tbody>
What I am trying to do is count the total number of meetings that all of my entities had within a certain month.
I imagine I need to use the COUNTIFS formula, but I can't seem to get it to search the cell for a particular value within a list of comma separated dates. Here is the COUNTIFS formula that I am trying to modify to search for a certain date within a cell that contains comma separated dates.
=COUNTIFS(AL$4:AL$323,">6/30/13",AL$4:AL$323,"<8/1/13")
Thank you very much for your help. I have been working on this for a several days and can not figure it out.
Last edited: