excel date range formula
Posted by Diane on February 03, 2002 2:00 PM
I am having a brain cramp. I need to create a formula that looks in one column and counts the number of cells that meets my criteria. The column is a column of dates in the format of: 01/01/945. I need the formula to count all of the dates that end in various years. For example, I need it to count all of the dates from 1994.
HELP!
Posted by Aladin Akyurek on February 03, 2002 2:43 PM
=SUMPRODUCT((YEAR(A2:100)=1994)+0)
will give you a count of all dates in A2:A100 that fall in 1994.
==============
