# How to make Make (Integromat) calculate formatDate() before sending to Google Sheets?

**URL:** <https://community.make.com/t/how-to-make-make-integromat-calculate-formatdate-before-sending-to-google-sheets/78757>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [April 15, 2025, 6:02am UTC](https://community.make.com/t/how-to-make-make-integromat-calculate-formatdate-before-sending-to-google-sheets/78757 "2025-04-15T06:02:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yarin\_Habany](https://avatars.discourse-cdn.com/v4/letter/y/e495f1/32.png) [@Yarin\_Habany](https://community.make.com/u/Yarin_Habany)\
**Post date:** [April 15, 2025, 6:02am UTC](https://community.make.com/t/how-to-make-make-integromat-calculate-formatdate-before-sending-to-google-sheets/78757/1 "2025-04-15T06:02:42Z")

</div>

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 🙏🏼

---

<div class="post-metadata">

**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\
**Post date:** [April 15, 2025, 11:48am UTC](https://community.make.com/t/how-to-make-make-integromat-calculate-formatdate-before-sending-to-google-sheets/78757/2 "2025-04-15T11:48:18Z")

</div>

Hi @Yarin_Habany,

To ensure your **“Date”** column is properly formatted and returns the correct **day of the week** , follow these steps:

1. Click on the **“Date”** column in your Google Sheet to select it.
2. Go to the **Format** menu, then hover over **Number**.
3. 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.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/0/802b6d00bea81fe7c616ab9f6eac6538a48026ec.jpeg)

**Best regards,**

**Msquare Automation**  
_Platinum Partner of Make_  
@Msquare_Automation

---

<div class="post-metadata">

**Author:** ![Yarin\_Habany](https://avatars.discourse-cdn.com/v4/letter/y/e495f1/32.png) [@Yarin\_Habany](https://community.make.com/u/Yarin_Habany)\
**Post date:** [April 15, 2025, 4:17pm UTC](https://community.make.com/t/how-to-make-make-integromat-calculate-formatdate-before-sending-to-google-sheets/78757/3 "2025-04-15T16:17:25Z")

</div>

Thanks friend!!!

---

<div class="post-metadata">

**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\
**Post date:** [April 16, 2025, 4:17am UTC](https://community.make.com/t/how-to-make-make-integromat-calculate-formatdate-before-sending-to-google-sheets/78757/4 "2025-04-16T04:17:22Z")

</div>

@Yarin_Habany

Anytime

**Best regards,**

**Msquare Automation**  
_Platinum Partner of Make_  
@Msquare_Automation

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [April 30, 2025, 8:16am UTC](https://community.make.com/t/how-to-make-make-integromat-calculate-formatdate-before-sending-to-google-sheets/78757/5 "2025-04-30T08:16:42Z")

</div>