Formatting dates inside Google Sheets

If you’re using formatDate, make sure the variable type of the field or cell accepts a string, not a date.

Also make sure that 1.date contains a Date type, not a date-like String. If it’s a date-like String type you’ll need to convert that into a Date type before you can use formatDate. For more information, see Wrong formatDate - #4 by samliew

2 Likes