It simply adds 1 to the previous date every thirty records, so record 31 is
A1 +1, record 61 is A1+2 etc. I am assuming consective dates are required.

So starting with 27/07/2006 (UK date format) in A1, A1 to a30=27/07/2006,
then A31 (to A60) will be 28/07/2006, A61 (to A90) will be 29/07/2006 etc

HTH

"Brooke" wrote:

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...