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...
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