Hey everyone,
I’m building an automation in Make where a form sends data to Google Sheets.
I want to take a date from the form, use formatDate() to get the day of the week, and insert the result into the sheet.
I’m using the format:
makeCopyEditformatDate({{1.Training Date}}; “dddd”; “Asia/Jerusalem”)
But instead of getting the result (“Monday”), the sheet shows the raw function text.
How can I make Make calculate the expression before inserting it into Google Sheets, instead of sending it as plain text?
Would love any help or example 
1 Like
Hi @Yarin_Habany,
To ensure your “Date” column is properly formatted and returns the correct day of the week, follow these steps:
- Click on the “Date” column in your Google Sheet to select it.
- Go to the Format menu, then hover over Number.
- From the dropdown, make sure “Date” is selected (as shown in the image).
This will apply the appropriate date format, allowing your weekday extraction logic to work as intended.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
3 Likes
@Yarin_Habany
Anytime
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
2 Likes
