How to enter dates?

D

dreidman

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
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top