Comparing date info

Posted by K Miles on November 23, 2001 3:28 PM

Is there a way to compare date fields based on periods? In other words, can you compare columns that contain dates ('01-15-2001', '05-22-2001', etc) to a column that contains 'May' so that the second cell is a match? Is there such a date function?

Posted by Aladin Akyurek on November 23, 2001 4:01 PM

Yes, you can. For example,

if column A contains

01-15-2001
05-22-2001
etc

and B1 "May", a 3-letter representation of the month name,

the following formula will return a count of matches:

=SUMPRODUCT((TEXT(A1:A8,"mmm")=B1)+0)

Aladin

Posted by K Miles on November 24, 2001 4:20 PM

Thanks for your help.