Forum Discussion

Deleted's avatar
Deleted
Apr 26, 2017

Dates formula

I am trying to count the number of individual dates within a specific date ranges (the dates relates to the date a person attended a client).  Have tried with the countif and if formula but not successful.  Please help

Excel on Mac
Formulas & Functions

3 Replies

  • manoj patgar's avatar
    manoj patgar
    Copper Contributor
    May 09, 2017

    Hi Johnson,

     

    Good day,

     

    Please try to use below formula. Formula may simplyfy your requirement but not completely fulfill your requirement because specific date range is not considered.

    Considering patient name in A colum (cell no. A51), and visited date in B column (cell no. B51). Since I have used SUMIF function I have added one more column i.e "sum_range" in column C (cell no. C51.

     

    =SUMIF(A51:A58,E51,C51:C58)

     

    Using SUMIF function:-    
          
    Patient name (if range)Visited onSum Range Patient nameNo. of time attended
    ABCD01-Jan1 ABCD3
    BCDE05-Jan1   
    CDEF10-Feb1   
    DEFG15-Feb1   
    ABCD01-Mar1   
    BCDE10-Mar1   
    ABCD01-May1   
    BCDE09-May1   

     

     

    For more clear understanding please use attached work sheet.

     

    Regards,

    Manoj P.

  • vijaykumar shetye's avatar
    vijaykumar shetye
    Brass Contributor
    May 03, 2017

    Dear Wendy,

    If your data is in cells A1 to a100,

    Minimum Date is in cell B1 and

    Maximum Date is in cell B2,

    Then use the below formula.

    =COUNTIFS($A$1:$A$100,">="&B1,A1:A19,"<="&B2)

     

    Change the cell references as required.

    Kindly let me know if this is what you wanted to do.

     

    Vijaykumar Shetye,

    Spreadsheet Excellence,

    Panaji, Goa, India

     

Resources