I received the answer on assigning consecutive dates but what can be done to
the formula

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

TO:

1. Not include weekends
2. Only assign the date to a certain person's name if there is multiple reps
on the spreadsheet.


Thank you so much.
Brooke Medvecky

"Brooke" wrote in message
...
I received the answer on assigning consecutive dates but what can be done
to
the formula

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

TO:

1. Not include weekends

Don't get your formula.

My suggestion

=A1+IF(WEEKDAY(A1)=6,3,1)


2. Only assign the date to a certain person's name if there is multiple
reps
on the spreadsheet.

Don't understand that bit.

Thank you for the formula. I will example. I have multiple sales people
within a spreadsheet. I want to only assign a date to one particular
individual within the spreadsheet without having to copy it into another
worksheet. Then, I want to assign the same date to 30 records. After those
30 assign the next day and so forth. I need to exclude weekends when
assigning dates.

Does this help? Please advise.
thanks
Brooke

"Bob Phillips" wrote:



"Brooke" wrote in message
...
I received the answer on assigning consecutive dates but what can be done
to
the formula

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

TO:

1. Not include weekends

Don't get your formula.

My suggestion

=A1+IF(WEEKDAY(A1)=6,3,1)


2. Only assign the date to a certain person's name if there is multiple
reps
on the spreadsheet.

Don't understand that bit.

Okay, I think I get it.

Try this

=INT($A$1+INT(ROW()-1)/30)+(WEEKDAY(INT($A$1+INT(ROW()-1)/30))=7)*2

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Brooke" wrote in message
...
Thank you for the formula. I will example. I have multiple sales people
within a spreadsheet. I want to only assign a date to one particular
individual within the spreadsheet without having to copy it into another
worksheet. Then, I want to assign the same date to 30 records. After
those
30 assign the next day and so forth. I need to exclude weekends when
assigning dates.

Does this help? Please advise.
thanks
Brooke

"Bob Phillips" wrote:



"Brooke" wrote in message
...
I received the answer on assigning consecutive dates but what can be
done
to
the formula

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

TO:

1. Not include weekends

Don't get your formula.

My suggestion

=A1+IF(WEEKDAY(A1)=6,3,1)


2. Only assign the date to a certain person's name if there is
multiple
reps
on the spreadsheet.

Don't understand that bit.

When I write this formula and use the start date 8-14-06 it is computing the
next date as 08-12-06. This would be the weekend date???

I just used your formula =A1+IF(weekday(A1)=6,3,1 and just then added /30.
So now it reads =A1+IF(WEEKDAY(A1)=6,3,1/30 - This excluded the weekend days
and then put a new date after every 30 records. Yeah.

Now can you tell me what 6,3,1 is all about? I want to understand the
formula and I'm not sure why you used those numbers.
Thanks so much for the quick responses.

"Bob Phillips" wrote:

Okay, I think I get it.

Try this

=INT($A$1+INT(ROW()-1)/30)+(WEEKDAY(INT($A$1+INT(ROW()-1)/30))=7)*2

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Brooke" wrote in message
...
Thank you for the formula. I will example. I have multiple sales people
within a spreadsheet. I want to only assign a date to one particular
individual within the spreadsheet without having to copy it into another
worksheet. Then, I want to assign the same date to 30 records. After
those
30 assign the next day and so forth. I need to exclude weekends when
assigning dates.

Does this help? Please advise.
thanks
Brooke

"Bob Phillips" wrote:



"Brooke" wrote in message
...
I received the answer on assigning consecutive dates but what can be
done
to
the formula

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

TO:

1. Not include weekends

Don't get your formula.

My suggestion

=A1+IF(WEEKDAY(A1)=6,3,1)


2. Only assign the date to a certain person's name if there is
multiple
reps
on the spreadsheet.

Don't understand that bit.

You have lost me. If you start with 14th Aug 2006, the next date is 15th, at
least it is in my tests. I fail to see how it could possibly count
backwards.

In my original formula, IF(WEEKDAY(A1)+6 just tests if the previous date is
a Friday, if some return 3 else return 1. The result of this test is added
to A1 to skip weekend dates.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Brooke" wrote in message
...
When I write this formula and use the start date 8-14-06 it is computing
the
next date as 08-12-06. This would be the weekend date???

I just used your formula =A1+IF(weekday(A1)=6,3,1 and just then added /30.
So now it reads =A1+IF(WEEKDAY(A1)=6,3,1/30 - This excluded the weekend
days
and then put a new date after every 30 records. Yeah.

Now can you tell me what 6,3,1 is all about? I want to understand the
formula and I'm not sure why you used those numbers.
Thanks so much for the quick responses.

"Bob Phillips" wrote:

Okay, I think I get it.

Try this

=INT($A$1+INT(ROW()-1)/30)+(WEEKDAY(INT($A$1+INT(ROW()-1)/30))=7)*2

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Brooke" wrote in message
...
Thank you for the formula. I will example. I have multiple sales
people
within a spreadsheet. I want to only assign a date to one particular
individual within the spreadsheet without having to copy it into
another
worksheet. Then, I want to assign the same date to 30 records. After
those
30 assign the next day and so forth. I need to exclude weekends when
assigning dates.

Does this help? Please advise.
thanks
Brooke

"Bob Phillips" wrote:



"Brooke" wrote in message
...
I received the answer on assigning consecutive dates but what can
be
done
to
the formula

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

TO:

1. Not include weekends

Don't get your formula.

My suggestion

=A1+IF(WEEKDAY(A1)=6,3,1)


2. Only assign the date to a certain person's name if there is
multiple
reps
on the spreadsheet.

Don't understand that bit.