I got it. Yeah! Now how does it recognize the next thirst records?? Or
will I have to post a new date after the previous 30????

"Toppers" wrote:

Put your starting date in A1 and this in A2 and copy down:

=INT($A$1+INT(ROW()-1)/30)

HTH

"Brooke" wrote:

I would like to have Excel assign a date to a specific line of records. I
would like it to assign a date to 30 records then assign the next date to the
next 30 records. Can this be done???

Example -
7-27-06 - 30 records should have this date
7-28-06 - The next 30 records would have this date
and so forth until all records have a date assigned to them.

Is there a formula I can write that would accomplish the above without
having to count each 30 records put the date then count the next 30 records,
etc...