Forum Discussion
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 ...
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.