+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : List of Dates, Events & Timeline

  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    List of Dates, Events & Timeline

    09/06/2008
    25/06/2008
    03/07/2008
    09/07/2008
    22/07/2008
    09/09/2008
    10/09/2008
    10/09/2008
    10/09/2008
    11/09/2008

    Hello, I wonder if you can help me! I have a list of 1000's of dates.

    Different events are happening on the same date. I need to count the number of events that are happening in every month in order to plot a timeline of trends over a few years.

    I need to end up with:

    January 2008 - 3
    February - 8
    March - 22 etc... in order to plot a chart.

    How would your ecommend I go about doing this?

    Thanks for your time.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: List of Dates, Events & Timeline

    You can add Pivot table and group them by months. Or by months and years.
    Attached Files Attached Files
    Last edited by zbor; 10-25-2011 at 06:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1