H
harnish
I'm using Excel 2000. Column A has four dates, Column B has the
person's name. I want to count how many dates in column A fall
between a date range. My data is below
A2 = 1-Apr-99
A3 = 1-Dec-99
A4 = 1-2Dec-99
A5 = 2-Jan-00
B2 = Mary
B3 = Peter
B4 = Paul
B5 = Susan
I want to know how many entries in column A fell between the dates of
April 1, 1999 and March 31, 2000, the count should be four. What
would be the appropriate COUNTIF formula? Pardon the pun but I've
lost count of how many variations I've tried to get my result. greatly
appreciated?
Any help would be Also, if some entries in column A were blank, would
that affect the formula?
person's name. I want to count how many dates in column A fall
between a date range. My data is below
A2 = 1-Apr-99
A3 = 1-Dec-99
A4 = 1-2Dec-99
A5 = 2-Jan-00
B2 = Mary
B3 = Peter
B4 = Paul
B5 = Susan
I want to know how many entries in column A fell between the dates of
April 1, 1999 and March 31, 2000, the count should be four. What
would be the appropriate COUNTIF formula? Pardon the pun but I've
lost count of how many variations I've tried to get my result. greatly
appreciated?
Any help would be Also, if some entries in column A were blank, would
that affect the formula?