+ Reply to Thread
Results 1 to 5 of 5

Counting data based on date

  1. #1
    Registered User
    Join Date
    01-03-2011
    Location
    Vermont
    MS-Off Ver
    Excel 2010
    Posts
    24

    Counting data based on date

    Hello all.

    I've searched but haven't found what I thought would be an easy formula!

    I have a column of dates formatted like mm/dd/yyyy from which I want to count the number of each year. I'm looking to use the =countif or =countifs formulas, but not sure how to ask for the year so it counts it.

    Suggestions?

    Thanks, Skeeterj

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Counting data based on date

    Would a Pivot Table be acceptable?

  3. #3
    Registered User
    Join Date
    01-03-2011
    Location
    Vermont
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Counting data based on date

    Sure! I need to learn more about them.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Counting data based on date

    A good place to start http://www.contextures.com/xlPivot07.html
    Don't forget to check first if your dates are real dates and not text looking like dates. You can use the ISTEXT() function to check

  5. #5
    Registered User
    Join Date
    01-03-2011
    Location
    Vermont
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Counting data based on date

    Thank you!

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Counting data based on date

    Be aware there are other possibilities

+ 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 if data falls on date between Start Date, End Date or Possible End Date
    By JessHasQuestions in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-26-2014, 08:01 AM
  2. Replies: 2
    Last Post: 08-17-2012, 04:56 PM
  3. Counting Based On 1 Date
    By xolite in forum Excel General
    Replies: 0
    Last Post: 04-11-2011, 04:17 PM
  4. Counting Based on Date
    By hanjimono in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2011, 11:30 PM
  5. Counting data based on a date period eg. Month
    By jennyp in forum Excel General
    Replies: 3
    Last Post: 01-17-2008, 09:02 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