vendredi 3 avril 2020

Google Sheets formula - change format of data

How to add to this formula if value is 1/1/1970 replace with blank value?

=ARRAYFORMULA(L2:L/86400000+DATE(1970,1,1))

I got data through API so I change format of data with this formula but I have values with 1/1/1970, I would like to have instead of these values only blank cells.

Aucun commentaire:

Enregistrer un commentaire