How to Checkbox if Date This Year in Google Sheets

Google Sheets Checkboxes That Auto-Check Based on Dates (This Year or Last 366 Days) The script explains how Google Sheets checkboxes represent TRUE/FALSE values and how to automate checking them based on dates in another column. It demonstrates entering formulas in checkbox cells so they evaluate to TRUE when a date’s year matches the current year using YEAR(TODAY()) (or a fixed year like 2026), then copying the formula down to flag matching rows. It notes that formula-driven checkboxes are no longer interactive because their TRUE/FALSE state comes from the referenced date cell. The video also shows a variation to check dates within the past year by testing whether a date is greater than TODAY()-366, and how changing the date values updates the checkbox results automatically. 00:00 Manual Checkbox Problem 00:14 Checkboxes Are True False 00:44 Auto Check This Year 01:57 Copy Down and Tradeoffs 02:38 Past Year Date Range 03:28 Wrap Up and Subscribe