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


Terms & Conditions