Count all cells in a row with the word "Monday"

Count all cells in a row with the word "Monday"

Hi,

Question 1

I am creating a sheet and I need to count how many rows has a certain partial string match.

I first tried to count all the rows with the word "Monday" by using this code:

COUNTIF(A1:A100;"*Monday*")

This displays 0 as a result, which is wrong. 

I then clicked on one of the date fields I want to sort and noticed that the underlying code for the date is different than the display in the cell. 

The cell displays: Monday, August 09, 2010

The underlying code displays: 08/09/2010

Is this related to my problem or is it just that my code is wrong?

Question 2

How do I reference to ALL the cells in a row. I would like to write A2:ALL instead of A2:A99999...

Thanks