# Formula Easymorph

**URL:** <https://community.easymorph.com/t/formula-easymorph/4686>\
**Category:** General Q&A\
**Created:** [July 31, 2023, 6:47am UTC](https://community.easymorph.com/t/formula-easymorph/4686 "2023-07-31T06:47:02Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bob\_Louis](https://community.easymorph.com/user_avatar/community.easymorph.com/bob_louis/32/5344_2.png) [@Bob\_Louis](https://community.easymorph.com/u/Bob_Louis)\
**Post date:** [July 31, 2023, 6:47am UTC](https://community.easymorph.com/t/formula-easymorph/4686/1 "2023-07-31T06:47:02Z")

</div>

I need to create a column that subtracts the date in this column from the date in another column to get the number of days between the two dates.

---

<div class="post-metadata">

**Author:** ![Jochen\_Marquardt](https://community.easymorph.com/user_avatar/community.easymorph.com/jochen_marquardt/32/5256_2.png) [@Jochen\_Marquardt](https://community.easymorph.com/u/Jochen_Marquardt)\
**Post date:** [July 31, 2023, 6:58am UTC](https://community.easymorph.com/t/formula-easymorph/4686/2 "2023-07-31T06:58:16Z")

</div>

Put just a simple - between these two fields. 🙂

Example:  
[Formula Easymorph.morph](https://community.easymorph.com/uploads/short-url/oR3evIq9HpJNa1YxWGs2ePkj1WQ.morph) (3.6 KB)

---

<div class="post-metadata">

**Author:** ![Bob\_Louis](https://community.easymorph.com/user_avatar/community.easymorph.com/bob_louis/32/5344_2.png) [@Bob\_Louis](https://community.easymorph.com/u/Bob_Louis)\
**Post date:** [July 31, 2023, 7:18am UTC](https://community.easymorph.com/t/formula-easymorph/4686/3 "2023-07-31T07:18:04Z")

</div>

Thank you sir.  
"Is there a way to create a column with a default date value as the last day of the current month?"

---

<div class="post-metadata">

**Author:** ![Jochen\_Marquardt](https://community.easymorph.com/user_avatar/community.easymorph.com/jochen_marquardt/32/5256_2.png) [@Jochen\_Marquardt](https://community.easymorph.com/u/Jochen_Marquardt)\
**Post date:** [July 31, 2023, 8:12am UTC](https://community.easymorph.com/t/formula-easymorph/4686/4 "2023-07-31T08:12:32Z")

</div>

You can use a formula like monthend(today()) .

---

<div class="post-metadata">

**Author:** ![Bob\_Louis](https://community.easymorph.com/user_avatar/community.easymorph.com/bob_louis/32/5344_2.png) [@Bob\_Louis](https://community.easymorph.com/u/Bob_Louis)\
**Post date:** [July 31, 2023, 8:26am UTC](https://community.easymorph.com/t/formula-easymorph/4686/5 "2023-07-31T08:26:35Z")

</div>

Sweet. Thank you sir 🖤

---

<div class="post-metadata">

**Author:** ![Bob\_Louis](https://community.easymorph.com/user_avatar/community.easymorph.com/bob_louis/32/5344_2.png) [@Bob\_Louis](https://community.easymorph.com/u/Bob_Louis)\
**Post date:** [August 4, 2023, 3:28am UTC](https://community.easymorph.com/t/formula-easymorph/4686/7 "2023-08-04T03:28:28Z")

</div>

Hello sir. Can you help me.

 ![IMG_3826](https://community.easymorph.com/uploads/default/original/2X/5/53bffd513117b6089c00b4292fc796b2733e200c.jpeg)

---

<div class="post-metadata">

**Author:** ![Jochen\_Marquardt](https://community.easymorph.com/user_avatar/community.easymorph.com/jochen_marquardt/32/5256_2.png) [@Jochen\_Marquardt](https://community.easymorph.com/u/Jochen_Marquardt)\
**Post date:** [August 4, 2023, 6:29am UTC](https://community.easymorph.com/t/formula-easymorph/4686/8 "2023-08-04T06:29:28Z")

</div>

Just use the aggregate action.

You should go through the tutorials [EasyMorph | Learn how to transform data](https://easymorph.com/learn.html)  
The action is described in the first chapter "basics".