Forum Discussion
Castellum812
Mar 02, 2022Brass Contributor
Conver Google Array function
Hi There, Have been struggling with this function for some time. =ARRAYFORMULA(EOMONTH(TODAY();SEQUENCE(1;MAX(N2:N);-1))+1) What is does. Creates a header in a sheet containing the ...
Riny_van_Eekelen
Mar 02, 2022Platinum Contributor
Castellum812 Perhaps this will work.
=EOMONTH(TODAY(),SEQUENCE(1,MAX(N:N),-1,1))
Use semi-colons in stead of commas the list separator is in your Excel set-up.