# How to calculate month end date in formula?

**URL:** <https://community.fibery.io/t/how-to-calculate-month-end-date-in-formula/2556>\
**Category:** Get Help\
**Created:** [February 16, 2022, 8:19pm UTC](https://community.fibery.io/t/how-to-calculate-month-end-date-in-formula/2556 "2022-02-16T20:19:06Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [February 16, 2022, 9:00pm UTC](https://community.fibery.io/t/how-to-calculate-month-end-date-in-formula/2556/2 "2022-02-16T21:00:50Z")

</div>

Just calculate the first of the next month and subtract a day:

```auto
Date(If(Month([Done Date]) = 12,Year([Done Date]) + 1,Year([Done Date])),If(Month([Done Date]) = 12,1,Month([Done Date]) + 1),1) - Days(1)

```

---

_[View the full topic](https://community.fibery.io/t/how-to-calculate-month-end-date-in-formula/2556)._