This arrayformula works in my spreadsheet:
=arrayformula(IF(A3:A<>"", DATEDIF(H3:H,"01/01/21","m"), ""))
This non-array is working:
=DATEDIF(MAX(datevalue(H3), "1/1/2021"),"01/01/22","m")
So I would think this would work as an arrayformula version of the working non-array:
=arrayformula(IF(A3:A<>"", DATEDIF(MAX(datevalue(H3:H), "1/1/2021"),"01/01/22","m"), ""))
Instead, I get this error:
DATEVALUE parameter '' cannot be parsed to date/time.
Can anyone please point me to what I might be doing wrong? Or why this arrayformula won't work?
Aucun commentaire:
Enregistrer un commentaire