Dear All,

I'm sure I'll kick myself when I figure out how to get this to work...

I have a SS (excel 2003) sheet 1 is data imported from a database

On sheet 2 I am building a summary page. I am trying to get a simple
countif to tell me how many orders I have received on each day in April. I
have a list of all the days (01/04/2008 ... 30/04/2008) my count if says
=COUNTIF(Sheet1!B:B,Sheet2!A13). Column B on sheet 1 conatins the date of
the order and A13 contains the day on my summary page, this formula has been
dragged down for day in April.

The results are all 0, which is not right. I suspect the problem has
something to do with the data in Sheet1 column B containing the date and
time, not just the date. How can I fix this, bearing in mind that Sheet1
needs to keep refershing from the database.

TIA

Matthew