# \[✔️DONE\] Date Ranges in Formulas

**URL:** <https://community.fibery.io/t/done-date-ranges-in-formulas/1739>\
**Category:** Ideas & Features\
**Tags:** formulas\
**Created:** [July 1, 2021, 5:50pm UTC](https://community.fibery.io/t/done-date-ranges-in-formulas/1739 "2021-07-01T17:50:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jim\_Larsson](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/jim_larsson/32/1489_2.png) [@Jim\_Larsson](https://community.fibery.io/u/Jim_Larsson)\
**Post date:** [July 1, 2021, 5:50pm UTC](https://community.fibery.io/t/done-date-ranges-in-formulas/1739/1 "2021-07-01T17:50:29Z")

</div>

So I get how to add days to a date using a formula. For example a button that extends Due date by 30 days:

`[Step 1 Task].[Due Date] + Days(30)`

How do I accomplish the same when using Date Time Range for Start and End dates?  
Add 30 days to date time range: Jul 1, 2021 00:00 → Jul 2, 2021 00:00

---

<div class="post-metadata">

**Author:** ![Oleg](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/oleg/32/1887_2.png) [@Oleg](https://community.fibery.io/u/Oleg)\
**Post date:** [July 2, 2021, 10:46am UTC](https://community.fibery.io/t/done-date-ranges-in-formulas/1739/2 "2021-07-02T10:46:52Z")

</div>

Hi, @Jim_Larsson

Thanks for feedback. We are working on additional functions for operating with date range as well. It should be appeared in nearest future.

Thanks,  
Aleh

---

<div class="post-metadata">

**Author:** ![antoniokov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/antoniokov/32/201_2.png) [@antoniokov](https://community.fibery.io/u/antoniokov)\
**Post date:** [September 27, 2021, 10:37am UTC](https://community.fibery.io/t/done-date-ranges-in-formulas/1739/3 "2021-09-27T10:37:08Z")

</div>

🎈 Introducing `DateRange(startDate, endDate)`, `DateTimeRange(startDateTime, endDateTime)`, and some auxiliar functions:

> [@CHANGELOG: Sep 27 / Milestones on Timeline, Date Ranges in Formulas, Filter Linked Entities in Rules](https://community.fibery.io/t/changelog-sep-27-milestones-on-timeline-date-ranges-in-formulas-filter-linked-entities-in-rules/2061):
>
> Milestones on a Timeline [https://community.fibery.io/t/in-dev-milestones-on-a-timeline/671](https://community.fibery.io/t/in-dev-milestones-on-a-timeline/671) Add crucial dates as milestones to any Timeline View: [milestones-on-timeline-fictional] Releases, conferences, product launches — everything preceded by firefire_engine time is a good candidate to visualize as a milestone. In a classic Fibery fashion, there are no hardcodes: pick any Type(s), any common Field, and use the usual filters to keep truly relevant events only. Date Ranges in Formulas a…

And a [guide](https://community.fibery.io/t/changelog-sep-27-milestones-on-timeline-date-ranges-in-formulas-filter-linked-entities-in-rules/2061) on date ranges in Formulas as well.

---

<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:** [October 4, 2024, 6:34am UTC](https://community.fibery.io/t/done-date-ranges-in-formulas/1739/4 "2024-10-04T06:34:09Z")

</div>