Delay Days Calculation

Delay Days Calculation

I Have create a planned day(Formula Type) to Calculate base on start date and End date , i have also created a delay day(Formula Type) to calculate base on End Date and Completion Date 

I have problem that I have issue that I am getting the value include weekend and holidays also in both Field but I need only days value of my working Hours (mon-sat) but doesn't count sunday's in it.

Planned Day function : DATETIME_DIFF({END DATE},{START DATE},'DAYS')
Delay Date Function : DATETIME_DIFF({COMPLETION DATE},{END DATE},'DAYS')

Anyone Can Solve This


      • Sticky Posts

      • Introducing the Zoho Projects Learning Space

        Every product has its learning curve, and sometimes having a guided path makes the learning experience smoother. With that goal, we introduce a dedicated learning space for Zoho Projects, a platform where you can explore lessons, learn at your own pace,

      • Update on V2 API End-of-Life Timeline

        Dear Users, Earlier this year, we shared the launch of the V3 APIs and requested users to migrate from the older V2 APIs by December 2025. We have received valuable feedback from our users and partners regarding their migration timelines. We are happy

      • Automation Series: Auto-update Phase Status

        Hello Folks! You can auto-update your phase's status based on status of underlying tasks using custom functions. In this series, we will showcase how to create and run custom functions, using Deluge, with ease. Follow the steps below and automate your

      • Automate Timesheet Approvals with Multi-level Approval Rules

        Introducing Approval Rules for Timesheets in Zoho Projects. With this automation, teams can manage how timesheets are reviewed and approved by setting up rules with criteria and assigning approvers to handle submissions. Timesheet, when associated to

      • Accessibility Spotlight Series - 1

        Every user interacts with products differently, what feels intuitive to one may be challenging for another. Addressing this, accessibility is built into Zoho Project's design philosophy. This helps users navigate and perform actions with ease irrespective