+ Reply to Thread
Results 1 to 3 of 3

Count how many times a date is listed on another sheet based on the date you select

  1. #1
    Registered User
    Join Date
    05-01-2012
    Location
    Gibraltar
    MS-Off Ver
    Excel 365
    Posts
    38

    Count how many times a date is listed on another sheet based on the date you select

    Hi good people

    I want to be able to count on sheet 1 (master) how many times a date is listed on sheet 2 (raw) based on the date that I select on sheet 1.

    Ideally I wanted a calendar on sheet 1 to select the date I want to count on sheet 2 but it seems that option isn't available in Excel 365 - I'd be glad to be proven wrong.

    I've attached a simple sheet showing what I want to achieve. E.g. 1 Aug is entered 2 times on sheet 2 and so on sheet 1 with that date selected I would like it to display a count of 2.

    Thank you in advance for your help, I've tried but don't have the knowledge to do this.
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Count how many times a date is listed on another sheet based on the date you select

    =COUNTIF(Raw!$B$4:$B$20,Master!$F$5)


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    05-01-2012
    Location
    Gibraltar
    MS-Off Ver
    Excel 365
    Posts
    38

    Re: Count how many times a date is listed on another sheet based on the date you select

    Thank you so much for the answer - works perfectly.

    I appreciate your time and support.

+ 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. Formula to count number of times a date is 15 or 28 in a date range
    By jojo412 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-03-2017, 08:30 PM
  2. [SOLVED] Formula to compare date (including month and year) from a listed date to today's date
    By mhewitson15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 05:31 PM
  3. Excel 2010 Slicers : use vba macro to only select last date listed ( always Now - 1 )
    By spencerpritchard in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2014, 02:25 PM
  4. [SOLVED] compare the number of times text is listed within a particular date
    By tlacloche in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2013, 12:34 PM
  5. Count by Person how many times Date 1 = Date 2
    By Azlodin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-27-2012, 11:55 AM
  6. Count how many times a given date falls between date pairs
    By XVar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-03-2009, 07:19 AM
  7. Select sheet based on userform date input
    By mugitty in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2006, 05:37 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