Formula to calculate numbers of actions from a date

[SimonGolding]

Hi I own a jobs board, I can export job application data to excel I would like to be able to turn this data into a simple graph that shows the number of job applications we have each day. I can work it out manually but I need a formula that adds up the applications in given day.

The data currently displays like this

JobId Name CreatedDate Id
723 Lee 09/05/2011 09:24 1
722 Elisabetta Indirli 09/05/2011 11:37 2
707 Shaneya Young 09/05/2011 13:56 3
674 MISS A LOUIS 09/05/2011 14:53 4
659 Chanelle 09/05/2011 16:58 5
721 Bradley Giles 09/05/2011 18:49 6
721 Bradley Giles 09/05/2011 18:49 7
493 Sunny Bedi 09/05/2011 18:58 8
729 Grezina Lita 09/05/2011 19:06 9
606 Sunny Bedi 09/05/2011 19:45 10
726 pravin 09/06/2011 06:29 11
688 Gurpreet 09/06/2011 12:40 12
729 GURPREET 09/06/2011 12:47 13
621 GURPREET 09/06/2011 12:56 14
725 Alice Groom 09/06/2011 19:41 15
676 Alice Groom 09/06/2011 19:43 16
707 shidan 09/06/2011 20:00 17
707 Krystal Russell 09/06/2011 21:09 18
722 Kristine Skarule 09/06/2011 21:52 19
707 Kristine Skarule 09/06/2011 21:55 20
717 killian 09/06/2011 22:05 21
717 Pervez Masud 09/06/2011 22:14 22
668 Kristine Skarule 09/06/2011 22:22 23
668 Kristine Skarule 09/06/2011 22:23 24
717 Ali Abbas Dar 09/06/2011 23:13 25
706 Gnanakumar 09/07/2011 04:48 26
727 Gnanakumar 09/07/2011 04:54 27
709 Gnanakumar 09/07/2011 05:06 28
704 Gnanakumar 09/07/2011 05:08 29

So from this data I can see we had 10 job applications on 09/05/2011, 16 on 09/06/2011 and 4 on 09/07/2011 but how do I get excel to work that out and then put it in a graph?

Thanks in advance!

 

[Andrew Poulsom]

Welcome to Mr Excel.

Create a pivot table with CreatedDate in the row area and Count of Id in the data area. Then right click the date field and group by days.

 

[SimonGolding]

Thank you Andrew that worked a treat!