How can I make 4 X 10's automatic?
 

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

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

"Aviator" wrote:

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

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?

"Peo Sjoblom" wrote:

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

"Aviator" wrote:

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

Aviator wrote:
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?

"Peo Sjoblom" wrote:

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

"Aviator" wrote:

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

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

Thanks,

Aviator

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

Aviator wrote:
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?

"Peo Sjoblom" wrote:

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

"Aviator" wrote:

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

Hi
try to explain in plain text first as a post :-)

--
Regards
Frank Kabel
Frankfurt, Germany

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

Thanks,

Aviator

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

Aviator wrote:
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?

"Peo Sjoblom" wrote:

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

"Aviator" wrote:

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

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



"Frank Kabel" wrote:

Hi
try to explain in plain text first as a post :-)

--
Regards
Frank Kabel
Frankfurt, Germany

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

Thanks,

Aviator

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

Aviator wrote:
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?

"Peo Sjoblom" wrote:

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

"Aviator" wrote:

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

To get 1. In D36 put


=IF($L$32="","",IF(WEEKDAY($L$32,2)5,$L$32+(WEEKD AY($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+(WEEK DAY(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

"Aviator" wrote:

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



"Frank Kabel" wrote:

Hi
try to explain in plain text first as a post :-)

--
Regards
Frank Kabel
Frankfurt, Germany

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

Thanks,

Aviator

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

Aviator wrote:
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?

"Peo Sjoblom" wrote:

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

"Aviator" wrote:

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