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
Monday, February 16, 2009

iLight
After years of groundwork, iLight2 is coming to Goshen College. On March 5, 9 a.m. iLight engineers will cut over GC's internet connection from a 45 Mb DS3 to a 1,000 Mb iLight2 fiber optic connection. How fast is that?  Consider that the average home cable internet connection is about 5 Mb, so iLight would be about 200 times faster.  Fast enough to deliver high resolution video and large research datasets.  The upgrade puts GC at the peer level with research universities across the globe, and creates research opportunities limited only by our imagination.  Cool stuff.
Login Button