Tip: Use Excel's Autofill to Generate a Series of Dates


Example:
  • Enter the beginning date of 10/3/06 in cell A3.
  • Drag A3's Fill Handle to cell A10. You now have a series of dates from 10/3/06 to 10/10/06.


  • To generate a series of dates that include only weekdays, using the right mouse button drag A3's Fill Handle to cell A10.
  • Select from the menu 'Fill Weekdays'. You now have a range of dates that only include weekdays.



News Archive
Friday, April 15, 2005

After six years with Goshen College and ITS, Tim Boshart has accepted a call to become Blackboard administrator at the University of Oregon in Eugene, OR. Tim's work with course management software began in 1999 when he set up the college's first CourseInfo server, which later became Blackboard. Over the years Blackboard has played an increasingly important role in the campus curriculum and become a mission critical service. Tim also played a key role in the college's migration to Linux file and print services, along with administering email, calendar, listservs and the campus firewall.  Tim, we'll miss you, but wish well in your new position.

Login Button