# Modify simple formula to count working days

**URL:** https://community.fibery.io/t/modify-simple-formula-to-count-working-days/5784
**Category:** Get Help
**Created:** [February 1, 2024, 6:04pm UTC](https://community.fibery.io/t/modify-simple-formula-to-count-working-days/5784 "2024-02-01T18:04:43Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![cire12](https://avatars.discourse-cdn.com/v4/letter/c/b5a626/32.png) [@cire12](https://community.fibery.io/u/cire12)
#### Post date: [February 1, 2024, 6:04pm UTC](https://community.fibery.io/t/modify-simple-formula-to-count-working-days/5784/1 "2024-02-01T18:04:43Z")

</div>

AI created the following formula to count days remaining for tasks that are not marked as “done”, pretty straightforward. However, when I try and get it to modify the formula to only count “working days” (Mon.-Fri.) it completely fails. How can I tweak this to only count working days? (Side note: I’ve seen other threads that talk about holidays, ect. and that’s not something I’m concerned about in this case).

If([State].[Name] != “Done”, ToDays([Date].End() - Today()), 0)

---

<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 1, 2024, 6:15pm UTC](https://community.fibery.io/t/modify-simple-formula-to-count-working-days/5784/2 "2024-02-01T18:15:47Z")

</div>

[https://the.fibery.io/@public/User\_Guide/Guide/How-to-Distinguish-Between-Business-Days-and-Holidays-Weekends-230](https://the.fibery.io/@public/User_Guide/Guide/How-to-Distinguish-Between-Business-Days-and-Holidays-Weekends-230)