Arrayformula Int

Question

How would I adjust this formula to not expand to infinity, but only expand if the adjacent row contains a value?

=ARRAYFORMULA({"Invoice Date"; INT(B2:B)})

thanks!

user_5632629 · Answer

like this:

=ARRAYFORMULA({"Invoice Date"; IF(A2:A="";;INT(B2:B))})