# Formula adds one day to Max dates

**URL:** <https://community.fibery.io/t/formula-adds-one-day-to-max-dates/1348>\
**Category:** Bugs & Issues\
**Created:** [February 4, 2021, 11:07am UTC](https://community.fibery.io/t/formula-adds-one-day-to-max-dates/1348 "2021-02-04T11:07:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Haslien](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/haslien/32/493_2.png) [@Haslien](https://community.fibery.io/u/Haslien)\
**Post date:** [February 4, 2021, 11:07am UTC](https://community.fibery.io/t/formula-adds-one-day-to-max-dates/1348/1 "2021-02-04T11:07:26Z")

</div>

I use two formulas that return Min and Max date of children to create a “total span”.  
The Max date gets an entire day added to it.

I have not done further testing on when this happens.

Replication:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/2c2c9250427474e01f2a7eb1d792cc76d5c0a8d2.png)  
**Feature:**  
**ETA:** Date with Start and End.

**Milestone:**  
**Start Date:** Formula with `Features.Min(ETA.Start)`  
**End Date:** Formula with `Features.Max(ETA.End)`

Result visualized using timeline:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/1/144b94818ca1b84f060780ade0a79b892c3c88c0.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/6/6e2296b61cc0a43f46b93f819b9b3b3c2c4bcab9.png)

---

<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 4, 2021, 5:55pm UTC](https://community.fibery.io/t/formula-adds-one-day-to-max-dates/1348/2 "2021-02-04T17:55:29Z")

</div>

Related to [this](https://community.fibery.io/t/converting-an-end-date-to-text/1302) I suspect.  
It would be nice to know how dates (without times) are managed under-the-hood, because I’ve experienced a few similar issues.