# Total of several values in field for points within polygons

I have ~4000 insurance claims for a city. I have made a fishnet and would like to count the number of claims within each polygon. It is easy to count the total number of claims, but I would like to find out how many claims there are within each cell for every claim date.

This is how the data set looks like:

``````    FID Shape       Name    Date
83  Point ZM    A2528   20030718
84  Point ZM    A2529   20100814
85  Point ZM    A2530   20140831
86  Point ZM    A2531   20140831
87  Point ZM    A2532   20140831
88  Point ZM    A2533   20110607
89  Point ZM    A2534   20120116
90  Point ZM    A2535   20100915
91  Point ZM    A2536   20100813
92  Point ZM    A2537   20140831
``````

As you can see, the flood claims are from different dates (~50). Does anyone of you have an idea how to solve this problem? I have read some similar Q&A's (Compute total area of several polygons within a polygon; Total of attribute field of point layer per polygon layer; How to write FIDs of points within each polygon to polygon field?), but could not find any answer that works in this case. The resulting table will consist of ~4000 rows (one for each cell) and ~50 columns (one for each claim date). The value in each field will tell how many flood claims there are in each cell for a certain date.

I work in ArcMap 10.1.