I would like to have excel assign a date to a specific line of records. I
would like it to include 30 records for each day. For Example -

7-31-06 - include 30 records
08-01-06 - include the next 30 records and so on.

Is there a formula that I could write that would automatically assign the
date to the first 30 records then assign a the next day to the next 30
records and so forth....?? I would not like to include weekends. I also
have multiple people on the list so it would have to be If the record
contained Joe Blows name assign this date for the next 30 records .....

Help????