assign a number to the same date & start over with 1 on new date

[Barbara]

I have a column of dates then I have a column called Date Sequence number.
I want the sequence number to start at 1 and increase by one on each row
until the Date changes, then I want the date sequence number to start over at
one and Keep increasing by one until the date changes again. The date will
always be the same on each row until then next day.
For example.

Date Date Seq Nbr
08/16/09 1
08/16/09 2
08/16/09 3
08/17/09 1
08/17/09 2
08/17/09 3
08/17/09 4
08/17/09 5
08/18/09 1
08/18/09 2
08/19/09 1
08/19/09 2
08/19/09 3
08/19/09 4

I will enter the Date filed on each row but I want the Date Seq Nbr to
automatically fill and increase without having to type it in.
Can this be done? If so how?

 

[Teethless mama]

In B2: =IF(A2="","",COUNTIF(A$2:A2,A2))

copy down as far as needed

 

[Barbara]

Wow! I don't understand why that works - wish I did. But I sure appreciate
the assistance! Thank you SO much!!

 

[T. Valko]

see your other post