1

This is the formula, currently. It outputs 12/30/1899, but it actually returns 0 and since TEXT() is forcing it into a data, this is how it shows. How to have this ARRAYFORMULA() populate the values and empty when there is no date?

FORMULA

=IF(I4<>"","Factura (USD)",
  ({"Wire Transfer Date";
        arrayformula(IFNA(
            TEXT(
            VLOOKUP($J$10:$J900,
              query(Datasets!S3:U,"select S, U"),2,0),
            "mm/dd/yyyy")
         )
       )
    }
  )
)

Current Output, which should be empty instead

enter image description here

I'd appreciate some help!

player0
  • 124,011
  • 12
  • 67
  • 124
onit
  • 2,275
  • 11
  • 25

1 Answers1

1

try:

=IF(I4<>"", "Factura (USD)", {"Wire Transfer Date"; 
 ARRAYFORMULA(SUBSTITUTE(IFNA(TEXT(VLOOKUP($J$10:$J900, 
 QUERY(Datasets!S3:U, "select S,U"), 2, ), "mm/dd/yyyy")), "12/30/1899", ))})
player0
  • 124,011
  • 12
  • 67
  • 124
  • 1
    Thanks a lot! I thought of replacing whichever year would come up that was smaller than 2022... Thank you! – onit Dec 27 '22 at 02:37