Need a summary of work by dates and counts of the date entries

[zshan]

[FONT=&quot]Hi, I need help with excel.[/FONT]
[FONT=&quot]I have database of my daily work tasks which includes different dates in one column and in the other columns I have other datas that are mostly in text. Now I need an excel code/function that can provide a "summary of tasks" that I did by each date listed and a respective count of how many tasks were completed on that specific dates. For example if only 10-december, I have 4 entries of work and on 11th-december, I had 14 then the excel should count and prepare a summary of my work like this[/FONT]
[FONT=&quot]Summary of Work[/FONT]
[FONT=&quot]Dates Tasks Completed[/FONT]
[FONT=&quot]10-december 4
11-december 14[/FONT]
[FONT=&quot]If somebody can prepare a format or a code and post it, I would really appreciate it. Please note, the excel code should also reflect any changes I make on the dates or counts. For example, if I find that the date was incorrect and I change it to say 12-december, the summary should reflect that right away.
thank you.[/FONT]

 

[arthurbr]

Hi
have you tried a Pivot Table http://contextures.com/CreatePivotTable.html