Skip to main content

I am trying to return a day of the week (dddd) from another column with a date formatted as MM/DD/YYYY, however I keep getting an error message.



This is the formula that I’m using:



=DATETIME_FORMAT({Sales Date},dddd)



Am I doing something wrong?



thank you!!

Your format string needs to be enclosed in quotation marks, and the equals sign is not needed.



DATETIME_FORMAT({Sales Date},"dddd")


Reply