Excel Tip for Teachers!

I learned something awesome and borderline life changing today! There is an easy way to fill in dates for data sheets! Check it out:

• Type in your "Start Date" (mine is 3/7/13 on this spreadsheet... I was adding on to a previous fill) then highlight the cells to the right (how many you think you will need, you can always add on)
• On the "Home" Tab click "Fill"
• Then scroll down and click "Series"

• Click "Weekday" and then click "OK"

• Then you will have all the weekdays filled in!



This was so easy and I know that it is going to save me SOOOO much time from here on out! (I hope someone else is as excited about this as I am!)