Format a date in shortest format possible indicating how many days have passed (Past date)
If date1-date2 < 8 Sat, Fri, …
If date1-date2 < 350 Dec24, Jan4, Aug14
Else 2020Feb4
Month: April 2023
Filter. Google Sheets function
Interesting seeing Google Sheets doing things differently than Excel. This function will fill in cells as values once the user presses Enter. Technically a feature rather than a function.
Once you do first cell, google sheets will fill the rest down with values, not formulas.