Forum Discussion
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 succe...
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.