# Equation Calculation for Work Days

**URL:** <https://forums.knack.com/t/equation-calculation-for-work-days/6152>\
**Category:** Feature Requests\
**Created:** [November 21, 2017, 11:59pm UTC](https://forums.knack.com/t/equation-calculation-for-work-days/6152 "2017-11-21T23:59:00Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![StephenChapman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/stephenchapman/32/1759_2.png) [@StephenChapman](https://forums.knack.com/u/StephenChapman)\
**Post date:** [November 21, 2017, 11:59pm UTC](https://forums.knack.com/t/equation-calculation-for-work-days/6152/1 "2017-11-21T23:59:00Z")

</div>

As a Knack builder, I want to calculate the number of business days between two date fields, so that I can accurately report on time spent working.

---

<div class="post-metadata">

**Author:** ![StephenChapman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/stephenchapman/32/1759_2.png) [@StephenChapman](https://forums.knack.com/u/StephenChapman)\
**Post date:** [July 4, 2018, 10:51pm UTC](https://forums.knack.com/t/equation-calculation-for-work-days/6152/2 "2018-07-04T22:51:00Z")

</div>

Well this was a surprise to me! Was a very subtle announcement for such a great feature:  
  
Glad to see this was addressed. Thanks Team Knack. :)

---

<div class="post-metadata">

**Author:** ![StephenChapman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/stephenchapman/32/1759_2.png) [@StephenChapman](https://forums.knack.com/u/StephenChapman)\
**Post date:** [December 14, 2017, 10:33pm UTC](https://forums.knack.com/t/equation-calculation-for-work-days/6152/3 "2017-12-14T22:33:02Z")

</div>

Thanks for the solution Jessie, but I believe this is aimed at a scenario where each date is an individual record.  
  
I should probably reiterate:  
  
One object called _Task_.  
_Task_ object has the fields _Start Date_ and _Finish Date._  
Ideally, the _Task_ object would have an equation field called _Work Days_ that measures the number of business days between {Task.StartDate} and {Task.FinishDate}.  
  
Another object called _Project_.  
_Project_ has many _Tasks__._  
_Project_ has a field to sum {Task.WorkDays}.

---

<div class="post-metadata">

**Author:** ![JulianKirkness](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/juliankirkness/32/770_2.png) [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)\
**Post date:** [November 24, 2017, 11:05am UTC](https://forums.knack.com/t/equation-calculation-for-work-days/6152/4 "2017-11-24T11:05:20Z")

</div>

It would also be useful if the calculation were able to take other non-work days into account (public holidays).

---

<div class="post-metadata">

**Author:** ![MattGreenw02587](https://avatars.discourse-cdn.com/v4/letter/m/a4c791/32.png) [@MattGreenw02587](https://forums.knack.com/u/MattGreenw02587)\
**Post date:** [November 24, 2017, 10:01am UTC](https://forums.knack.com/t/equation-calculation-for-work-days/6152/5 "2017-11-24T10:01:31Z")

</div>

Second this.

---

<div class="post-metadata">

**Author:** ![petraLewis30702](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/petralewis30702/32/893_2.png) [@petraLewis30702](https://forums.knack.com/u/petraLewis30702)\
**Post date:** [January 15, 2016, 10:57pm UTC](https://forums.knack.com/t/equation-calculation-for-work-days/6152/6 "2016-01-15T22:57:00Z")

</div>

I would love a feature that enables date calculations by working days rather than 7 day weeks - this would be great for us to record vacation days needed etc.

---

<div class="post-metadata">

**Author:** ![Jessie](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/jessie/32/5_2.png) [@Jessie](https://forums.knack.com/u/Jessie)\
**Post date:** [August 4, 2021, 5:38pm UTC](https://forums.knack.com/t/equation-calculation-for-work-days/6152/7 "2021-08-04T17:38:00Z")

</div>

🧹 Housekeeping! Closing this one out, as we released a **netWorkDays** numeric equation function some time ago.

> **[Numeric Equation Functions](https://learn.knack.com/article/0xstljj9ta-numeric-equation-functions)**

---

<div class="post-metadata">

**Author:** ![Jessie](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/jessie/32/5_2.png) [@Jessie](https://forums.knack.com/u/Jessie)\
**Post date:** [August 4, 2021, 5:38pm UTC](https://forums.knack.com/t/equation-calculation-for-work-days/6152/8 "2021-08-04T17:38:08Z")

</div>