Dates formula

[Deleted]

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

[#2]

Hi Wendy,

The approach how to count distinct number of dates (or whatever) is described here

https://exceljet.net/formula/count-unique-values-in-a-range-with-countif

if with criteria

https://exceljet.net/formula/count-unique-text-values-with-criteria

[#3]

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

[#4]

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 on	Sum Range		Patient name	No. of time attended
ABCD	01-Jan	1		ABCD	3
BCDE	05-Jan	1
CDEF	10-Feb	1
DEFG	15-Feb	1
ABCD	01-Mar	1
BCDE	10-Mar	1
ABCD	01-May	1
BCDE	09-May	1

For more clear understanding please use attached work sheet.

Regards,

Manoj P.