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!

CodePudding user response：

like this:

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