How to enter dates?
 

I am new to excel. I have been tasked with creating a work schedule for 20
people on a previously established excel spread sheet/ schedule. However, it
was for the last academic year and therefore the dates for each given weekday
are off. Is there any way that excel can automatically fill these dates in if
I enter a start and end date for each cycle, we have academic months not
calender months. What I would like to do is create a row that started with,
say, 8 July and ends with 22 August and have the program fill in the interval.
Is this possible and if so how can I do it.

Thank you in advance for your help.

Dan

One way:
Enter the first date. Drag that cell by the fill handle in the lower right
corner as far as you want. Excel will fill in the dates. HTH Otto
"dreidman" wrote in message
...
I am new to excel. I have been tasked with creating a work schedule for 20
people on a previously established excel spread sheet/ schedule. However,
it
was for the last academic year and therefore the dates for each given
weekday
are off. Is there any way that excel can automatically fill these dates in
if
I enter a start and end date for each cycle, we have academic months not
calender months. What I would like to do is create a row that started
with,
say, 8 July and ends with 22 August and have the program fill in the
interval.
Is this possible and if so how can I do it.

Thank you in advance for your help.

Dan

Worked perfectly.
Thanks so much for your help.

- Dan

"Otto Moehrbach" wrote:

One way:
Enter the first date. Drag that cell by the fill handle in the lower right
corner as far as you want. Excel will fill in the dates. HTH Otto
"dreidman" wrote in message
...
I am new to excel. I have been tasked with creating a work schedule for 20
people on a previously established excel spread sheet/ schedule. However,
it
was for the last academic year and therefore the dates for each given
weekday
are off. Is there any way that excel can automatically fill these dates in
if
I enter a start and end date for each cycle, we have academic months not
calender months. What I would like to do is create a row that started
with,
say, 8 July and ends with 22 August and have the program fill in the
interval.
Is this possible and if so how can I do it.

Thank you in advance for your help.

Dan