 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / January 2006How to create a formula to create a list of dates in a column
Hello, I am a teacher and I have to develop a course matrix. The course has a duration of 2 months. I would like to come up with a formula that allows me to write the first date in the column (i.e Tuesday, September 26, 2006 ) and the program write the rest of the dates all the way to the end of the course. Thanks Leo On 1/29/06 12:47 PM, in article 1138556842.852419.185140@g47g2000cwa.googlegroups.com, "Leo" <raptor1680@yahoo.com> wrote: > Hello, I am a teacher and I have to develop a course matrix. The course > has a duration of 2 months. I would like to come up with a formula that [quoted text clipped - 3 lines] > Thanks > Leo Just format the column for dates in the manner desired. Then simply add 1 to the value in the prior cell and fill down for the length needed.  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom Assuming you want to include _all_ dates rather than just weekdays, once you type the starting date & format the cell, go to Edit>Fill>Series. Select Column, confirm Date & Step Value: 1, then type the ending date in the Stop Value: box (probably 11/25/2006 in this case). When you click OK the list of dates will be generated. HTH |:>) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.