"Steved" wrote...
....
The objective is in Col D which is empty I would Like to put add a count
function.

I think one frustration Tyro might have is that you seem to be writing too
quickly, which might explain the phrase 'to put add', which doesn't make
sense but which maybe you meant 'to put or add'.

If duplicates are found then do a count for example if the next 5 rows
contain the same information the put value 1 to 5 Cell D1 will have value
1, Cell D2 will have the Value 2, Cell D3 will have value 3 for example,
as set out below.

And here, 'the put value' perhaps should have been 'then put value'.

Col A Col B Col C Col D
30/07/2007, 1004, 15:30, 1
31/07/2007, 1004, 15:30, 2
1/08/2007, 1004, 15:30, 3
2/08/2007, 1004, 15:30, 4
30/07/2007, 1005, 15:30, 1
31/07/2007, 1005, 15:30, 2
2/08/2007, 1005, 15:30, 3
3/08/2007, 1005, 15:30, 4
30/07/2007, 1007, 15:20, 1
30/07/2007, 1007, 15:20, 2
31/07/2007, 1007, 15:20, 3
31/07/2007, 1007, 15:20, 4
1/08/2007, 1007, 15:20, 5
2/08/2007, 1007, 15:20, 6
2/08/2007, 1007, 15:20, 7
3/08/2007, 1007, 15:20, 8

Looks like col D depends on col B. If this table began in row 1, so spanned
A1:D16, try

D1:
1

D2:
=IF(B2=B1,D1+1,1)