Counting cell between two different dates
Posted by Trish Proulx on October 04, 2001 1:05 PM
How does one create a formula to count the number of
cells that fall between two specific dates.(i.e. Count
number of cells that are equal to or greater than
October 1, 2001 and equal to or less than October 31,
2001)Any help would be appreciated.
Posted by Juan Pablo on October 04, 2001 1:07 PM
If your cells are in A2:A200 put
in D1 = Oct 1, 2001
in D2 = Oct 31, 2001
and in D3
=SUMPRODUCT((A2:A200>=D1)*(A2:A200<=D2))
Juan Pablo
-----------
Posted by Trish Proulx on October 04, 2001 1:35 PM
Thank you very much for your quick response. It worked, yea-haw! Thank you, thank you, thank you.
