The cells were "general" format, but, when I changed them to date format, I
still get the same error message. If I use the LEFT(A2,2) function, it
returns "1/", so it appears to me that number is formatted ok.
--
Alan


"Richard Buttrey" wrote:

On Fri, 25 Aug 2006 16:29:02 -0700, AG
wrote:

When I enter this formula into my spreadsheet, I get an error message. Here
is how the data is loaded into the spreadsheet:
date hours
1/1/05 36.5
12/15/05 15.2
8/8/05 24.0

I need to select the data in the "hours" column based on the month in the
"date" column.

Are the dates real Excel date numbers, or just text strings?

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________