Thank you for your help. However, I am not getting what I need. I need to
identify each series of dates with a number like this. Thank you

Ad DT
Dis DT
Ap Dt New Column

01/01/08 1
02/01/08 2
03/01/08 3

05/01/08 1
06/01/08 2
07/01/07 3





"Roger Govier" wrote:

Hi

In cell B5, enter the following and copy down as far as required
=IF(A5="","",N(B4)+1)

--
Regards
Roger Govier

"TotallyConfused" wrote in
message ...
Thank you so much for responding so quickly - very much appreciated. I
entered the formula you provided and this is what I got back

1
39357
39397

39403
39403
39403

Why am I not getting back the following:???

1
2
3

1
2
3


"Ashish Mathur" wrote:

Hi,

Try this

Against 01/01/08, enter 1 (in the next column), say B1. In the row below
(I.e. B2), enter the following formula
=IF(COUNTBLANK(A2)=1,"",MAX($B$1:B1)+1)

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"TotallyConfused" wrote in
message ...
I have columns instead of rows with data. Transpose does not work with
this.

Ad DT
Dis DT
Ap Dt

01/01/08
02/01/08
03/01/08

05/01/08
06/01/08
07/01/07

and so forth. I wan to be able to flag 1st date as 1, 2nd as 2 and 3rd
as
3. In between there are blank rows. How do I do this please???