Recording just a month and a year

May consider below to make things better:

Excel works best when you use a valid date format, please consider to use:

01/01/2026

Then format the cell to display only Month-Year:

Format Steps:

1. Select the column with your dates.
2. Right-click > Format Cells.
3. Choose Custom.
4. Enter this format:

5. mmm-yyyy

or

yyyy-mm

This way:

• Excel stores it as a real date (which is sortable and filterable).
• You can group by Month and Year in pivot tables.
• You avoid issues with text sorting (e.g., "Apr" before "Feb").

Pivot Table Setup

Once your data is structured with real dates:

1. Insert a Pivot Table.
2. Drag your completion date into the Rows field.
3. Right-click a date > Group > choose Months and Years.
4. Add your book/game title to Values or Columns as needed.