+ Reply to Thread
Results 1 to 2 of 2

Formula to count dates

  1. #1
    Registered User
    Join Date
    03-31-2008
    Posts
    11

    Formula to count dates

    Hi I Need a formula that can count the following dates but not the double ups. So for example
    there are 2 (17/2/2012) the formula should only count this as 1

    17/02/2012
    21/02/2012
    17/02/2012
    24/02/2012
    22/02/2012
    24/02/2012
    23/02/2012
    20/02/2012
    23/02/2012
    25/02/2012
    22/02/2012
    25/02/2012
    25/02/2012
    18/02/2012
    25/02/2012
    27/02/2012
    27/02/2012
    27/02/2012
    6/03/2012
    27/02/2012
    20/02/2012
    20/02/2012
    25/02/2012
    23/02/2012
    20/02/2012
    22/02/2012
    23/02/2012
    21/02/2012
    29/02/2012
    22/02/2012
    18/02/2012
    18/02/2012
    1/03/2012
    23/02/2012
    2/03/2012

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Formula to count dates

    If data is in A2:A100 try this formula

    =SUMPRODUCT((A2:A100<>"")/COUNTIF(A2:A100,A2:A100&""))
    Audere est facere

+ 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