Anyone -

I'm trying to count monthly data within a date range and am having trouble.
i have data listed by day. i converted the dates for each occurrence from
mm/dd/yyyy (ex. 2/28/06) to a custom format, mmm-dd (ex. feb-06), and then
did a countif function to count the data that fell under a given month. But
the countif function doesn't recognize the mmm-dd format even though it's
displayed in the cell. it only recognizes the original date format 2/28/06
even when it is not formatted as such.

is there anything i can do? the bottom line is i have a huge column of
daily data that i want to count and sum by month...

This is because COUNTIF() can't "see" the format, only the value. Instead of
formatting 2/28/2008 as mmm-dd, use another cell (another column) with:

=TEXT(A1,"mmm")

Now COUNTIF can "see" and count the FEBs
--
Gary''s Student - gsnu200771


"martinbarnes" wrote:

Anyone -

I'm trying to count monthly data within a date range and am having trouble.
i have data listed by day. i converted the dates for each occurrence from
mm/dd/yyyy (ex. 2/28/06) to a custom format, mmm-dd (ex. feb-06), and then
did a countif function to count the data that fell under a given month. But
the countif function doesn't recognize the mmm-dd format even though it's
displayed in the cell. it only recognizes the original date format 2/28/06
even when it is not formatted as such.

is there anything i can do? the bottom line is i have a huge column of
daily data that i want to count and sum by month...

You are the man...or woman. thanks a ton for the help.

"Gary''s Student" wrote:

This is because COUNTIF() can't "see" the format, only the value. Instead of
formatting 2/28/2008 as mmm-dd, use another cell (another column) with:

=TEXT(A1,"mmm")

Now COUNTIF can "see" and count the FEBs
--
Gary''s Student - gsnu200771


"martinbarnes" wrote:

Anyone -

I'm trying to count monthly data within a date range and am having trouble.
i have data listed by day. i converted the dates for each occurrence from
mm/dd/yyyy (ex. 2/28/06) to a custom format, mmm-dd (ex. feb-06), and then
did a countif function to count the data that fell under a given month. But
the countif function doesn't recognize the mmm-dd format even though it's
displayed in the cell. it only recognizes the original date format 2/28/06
even when it is not formatted as such.

is there anything i can do? the bottom line is i have a huge column of
daily data that i want to count and sum by month...