Code Yarns ‍👨‍💻
Tech BlogPersonal Blog

How to make calendar in spreadsheet

📅 2020-Apr-14 ⬩ ✍️ Ashwin Nanjappa ⬩ 🏷️ ⬩ 📚 Archive

 
 

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.

Tue
Wed
Thu
// Drag down fill handle on above cells to get a series of weekdays
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.

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.