top of page
Count cells between dates.png

Count cells between date


Generic Formula


=COUNTIFS(range,">="&date1,range,"<="&date2)


Explaination


To count the number of cells that contain dates between two dates, you can use the COUNTIFS function.  In the example shown, F5 contains this formula:

bottom of page