Try replacing all the semi-colons with commas. Some international locations
use the semi-colon as the argument separator and some use the comma.

Even if you get the formula straightened out and Excel will accept it I'm
wondering if Excel will recognize your entries as true Excel dates/times:

(example 10/2/2009 03:12)

If I enter 10/2/2009 03:12 in a cell Excel treats it as a TEXT string. If I
remove the leading 0 in the time portion *then* Excel treats it as a true
Excel date/time.

--
Biff
Microsoft Excel MVP


"wally" wrote in message
...
Per;
I'm sorry, but I could not make your suggestion work. When pressing ENTER
an error dialog box appears and the first S233 is highlighted. Can you
tell
me what I'm doing wrong? I would like to better understand your
suggestion.
Thanks.
Wally

"Per Jessen" wrote:

Hi

This will count number of events in January in range F2:S233

=COUNTIF(F2:S233;"=" &DATE(2009;1;1))-COUNTIF(F2:S233;"=" &
DATE(2009;2;1))

The second parameter in the DATE function is the month, and has to be
increased by 1 to count events for February.

Hopes this helps.
....
Per

"wally" skrev i meddelelsen
...
In a spreadsheet I have dates and times of events (example 10/2/2009
03:12)
in cells F2:S233. I need to count the events by month, ie January had
'x'
number of events, February had 'x' number of events, and so on. For my
need,
the time is irrelevant. Your suggestion would be appreciated. Thanks.

.