+ Reply to Thread
Results 1 to 4 of 4

counting dates

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    Antrim
    MS-Off Ver
    Excel 2010
    Posts
    1

    counting dates

    using excel 2010 need to count the number of dates a customer made contact over a year month by month can anyone help with a formula for this?

  2. #2
    Registered User
    Join Date
    01-12-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: counting dates

    Your statement is vague, but have you tried a pivot table?

  3. #3
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: counting dates

    Would this help?
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-12-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: counting dates

    Copy of dates.xlsx see if this works for you. I just made a pivot table, and then on the dates I right clicked and selected Group By.

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: counting dates

    Here's a formula method.

    Data Range
    A
    B
    C
    D
    E
    F
    G
    H
    1
    Customer
    Date
    Customer
    Jan
    Feb
    Mar
    Apr
    2
    A
    2/23/2013
    A
    0
    1
    0
    1
    3
    A
    4/10/2013
    X
    1
    1
    2
    2
    4
    X
    1/17/2013
    Y
    0
    2
    1
    0
    5
    X
    2/10/2013
    Z
    0
    0
    1
    2
    6
    X
    3/2/2013
    7
    X
    3/10/2013
    8
    X
    4/7/2013
    9
    X
    4/30/2013
    10
    Y
    2/6/2013
    11
    Y
    2/28/2013
    12
    Y
    3/29/2013
    13
    Z
    3/15/2013
    14
    Z
    4/1/2013
    15
    Z
    4/10/2013


    This formula entered in E2:

    =SUMPRODUCT(--($A$2:$A$15=$D2),--(TEXT($B$2:$B$15,"mmm")=E$1))

    Copy across then down as needed.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting number of unique dates per month in a list of duplicate dates
    By Rackle83 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-22-2013, 10:15 AM
  2. Manipulating intake & discharge dates, counting between dates
    By lisast in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-02-2013, 03:59 AM
  3. Replies: 1
    Last Post: 11-01-2012, 03:41 PM
  4. Overlapping Dates, Gaps in Dates, Double Counting
    By sglxl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2012, 02:46 AM
  5. Replies: 4
    Last Post: 12-16-2011, 02:55 PM

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