B
Brooke
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????
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????