How can I make 4 X 10's automatic?

A

Aviator

I am trying to do something with dates on exel. The problem is that we work a
4 X 10 schedule. I want to be able to type in a start date and have the rest
of the dates automaticly fill in. I guess there is two things I am trying to
learn.

1. How do I make it so dates automaticly fill in?
2. How do I make it fill in using a 4 X 10 schedule?

Please Help!

Thank you,

Aviator
 
P

Peo Sjoblom

You can't really autmate this without first creating the formulas, assume A2
would the cell with the start date, then you can refer to this cell in the
other cells like

=IF(A2="","",A2+1) (will add one day to the date in A2 unless A2 is empty
and so on)

I am afraid you need to to do some manual work first and then it will look
like it is
automated later.

Regards,

Peo Sjoblom
 
A

Aviator

OK. I am more than happy to have a formula in the cells to make this work.
The formula you gave me was great, except I need it to be something that will
only input Monday thru Thursday (our 4 X 10 schedule). Is this possible with
excel?
 
F

Frank Kabel

Hi
you may provide some more information. e.g. an example how the expected
result should look like :)
 
A

Aviator

Do you want me to e-mail you an attachment so you can see what I am trying to
do?

Thanks,

Aviator
 
A

Aviator

OK. I will do my best.

1. How do I make it so dates automaticly fill in?
I have created a box (L32) in which you enter the scheduled start date. I am
wanting to have this date start the calender (which is on the same worksheet)
and fill in the rest of the dates on the calender using just the week days. I
have the calender set up in a single row (D36:AD36).


2. How do I make it fill in using a 4 X 10 schedule?
With this I am wanting the same as #1 the difference is that instead of
weekdays, I just want dates Monday through Thursday.

Is the feasibly?

Thank you,

Aviator
 
P

Peo Sjoblom

To get 1. In D36 put


=IF($L$32="","",IF(WEEKDAY($L$32,2)>5,$L$32+(WEEKDAY($L$32)>2)*7-WEEKDAY($L$32)+2,$L$32))

in E36 put

=IF(D$36="","",IF(WEEKDAY(D$36+1,2)>5,D$36+1+(WEEKDAY(D$36+1)>2)*7-WEEKDAY(D$36+1)+2,D$36+1))

copy across to AD36


For 2. Just change the >5 in all places of the formulas to >4
otherwise repeat


Regards,

Peo Sjoblom
 
Top