Date functions YEAR, MONTH, EOMONTH do not work for the array format?

Are you trying to accomplish a specific task? Perhaps give some details of what you want to calculate.

Year and other date functions can normally accept array inputs....but the result will also be an array so you either need to enter the formula in a range in excel to return that whole array, or use the resultant array within another function that can handle arrays.