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
Tuesday, August 05, 2008
iMac
For the last 10 years, Goshen College has had a 15 seat Mac lab in UN 001 dedicated to the teaching of graphic design and video production classes.  This fall, that's going to change--for the better.  UN 004 will sport 24 20" iMacs that run both Mac OS X Leopard and Windows.  That means that classes that used to be limited to 15 students because of the limited number of Macs in UN 001, can now be offered to 24 students.  UN 001 will be closed for Fall 2008.  Congratulations go to Dan Stutzman, Paul Ortman and Kevin Gross for their work to make this innovative upgrade feasible!
Login Button