How to make calendar in spreadsheet

Spreadsheets lend themselves to all sorts of data entry and analysis. I recently discovered that they are excellent to create your own calendars to note or track events or tasks associated with dates. This works in both Google Sheets and Microsoft Excel with equal ease. One of the advantages of such calendars is that you can get a sense of an entire month or year in just a single glance.

• Days: To create a continuous series of weekdays, enter a few of the weekdays in order, mark those cells and drag the fill handle. For example:

Tue
Wed
Thu
// Drag down fill handle on above cells to get a series of weekdays

• Dates: To create a continuous series of dates, enter a few valid dates in a series, mark those cells and drag the fill handle. For example:

4/29
4/30
5/1
5/2
5/3
// Drag down fill handle on above cells to get a series of dates

If you skip the year, then the dates are filled out for the current year.

• Week: To create a series of week dates, enter at least two rows of valid week dates (7 dates to each week) and then drag the fill handle. For example:

4/13 4/14 4/15 4/16 4/17 4/18 4/19
4/20 4/21 4/22 4/23 4/24 4/25 4/26
// Drag down fill handle on above rows to get a series of week dates

Once I have created the calendar I want, I can enter data into one of its cells by either appending a newline to the date (Ctrl+Enter) or adding a note to the cell.