View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] tkennady@xrqcorp.com is offline
external usenet poster
 
Posts: 1
Default 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.