sumproduct with date range

[vasto]

I am trying to create a formula to count the number of rows that have a date greater than 11-mar-84 in column AA, I used the following formula and it returned 0, and I know there are some.
=SUMPRODUCT('102_CAM_LOYALTY_TRACKING'!AA2:AA1000>DATEVALUE("11-mar-84"))

Also need a formula to count the amount of rows in column B that have a date range of 06-mar-09 to 13-Mar-09.

[DonkeyOte]

For 1 condition use a standard COUNTIF

=COUNTIF('102_CAM_LOYALTY_TRACKING'!AA2:AA1000,">11-MAR-84")

For your other formula I would suggest you use:

=SUM(COUNTIF('102_CAM_LOYALTY_TRACKING'!B2:B1000,{">=06-MAR-09",">13-Mar-09"})*{1,-1})

ie given 1 condition can be applied twice better to use COUNTIF and SUM than use array (Sumproduct).