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.



About DevCorps

DevCorps is a select group of talented Goshen College student programmers teamed up with our professional ITS systems developers. Together, they're extending GC Online services and the Caravel Web Content Management System in strategic ways.

Theodore Budiardja and his student co-workers are implementing a new generation of development tools and Internet technologies to improve our ability to serve up information when and where it's needed.

Login Button