# EDATE in Excel formula is not working

**URL:** <https://community.glideapps.com/t/edate-in-excel-formula-is-not-working/42998>\
**Category:** Report a Bug\
**Created:** [June 12, 2022, 6:38pm UTC](https://community.glideapps.com/t/edate-in-excel-formula-is-not-working/42998 "2022-06-12T18:38:45Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [June 27, 2022, 8:50pm UTC](https://community.glideapps.com/t/edate-in-excel-formula-is-not-working/42998/7 "2022-06-27T20:50:46Z")

</div>

So I managed to run formulas in excel by creating a column template and replacing the values in it, mostly the issue was because the I can’t add Double Quotations in the Excel formula like the image below

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd19c8f49f22773b0282e9d1eb4db0f43170a41f.png)

But the workaround is to prepare the excel formula in a template column to ensure that all the text is exactly brought from the backend properly to send it to the formula column as below

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ade3ad0bfdc3acf724a12cbd8b9ea24541499a69.png)

Then map it to the excel formula column will work eventually

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/9/f920d5063d8e98b7c3b11e89473903de6ba4128c.png)

---

_[View the full topic](https://community.glideapps.com/t/edate-in-excel-formula-is-not-working/42998)._