Bussiness days

PavanKumar2 — Wed, 20 Mar 2019 11:04:30 GMT

Hi team,

I am adding another requirement.

I have Planned Start Date as 10 th March 2019 and Planned End Date as 21 th March 2019.

current date:20 th March 2019

Result I am getting:

Planned Difference in Days - 11 days

Remaining days - 1 day(21 st March 2019 - 20 th March 2019)

But 10 th march 2019 - sunday and 16 th march 2019 Saturday and 17 th march 2019 sunday. I want to eliminate Weekends.

Result I need :

No of Business Days = 7 days.

Remaining days = 1 day

Remaining days vs Planned : (1 day out of (7 days) as sinlge column to display

Please Help me.

Regards,

Pavan.

Re: Bussiness days

Arjen — Wed, 20 Mar 2019 13:24:34 GMT

You could use the INTCK function for this. This allows you to calculate the number of weekdays between two days, like in the following example:

diff = intck('WEEKDAY', start_date, end_date)

Chris Hemedinger wrote a blog entry with a function that will consider holidays as well. You can find it here: