YEAR result from an ArrayFormula, or Query function
I have a date in column J [01/01/2019]
I need column AS to show JUST the 2019 Year, and I need (strongly want) a header that says "YEAR". I cant have the formula in the row 2 because of sorting. or can I?
I don't want to drag a formula endlessly down... I would like an arrayFormula or Query solution.
Thank you.
|