3 Replies Latest reply on Apr 23, 2018 5:40 PM by NAYANA MADHEKAR

Hello,

I need to divide one calculation by no. of business days in that year..

I have Project start date & project End Date:

Hours worked = 20 hours in that Duration. (Project start date - project end date)

Hours contracted is constant = X

Need to calculate :::( Hours Worked/ Hours contracted)/ NO. OF BUSINESS DAYS..

how do I calculate no. of business days?

thank you.

• ###### 1. Re: Calculate Business Days only

HI Nayana

Not sure without seeing any data, but this might help?

Thanks,

Shin

• ###### 2. Re: Calculate Business Days only

DATEDIFF('week',MIN([Start Date]),[End Date])*5 - MIN(DATEPART('weekday',[Start Date],6)

+ MIN(DATEPART('weekday',[End Date],6)+(IF DATENAME('weekday',[Start Date])='Saturday' OR DATENAME('weekday',[Start Date])='Sunday' THEN 0 ELSE 1 END)

Regards,

Ritesh

• ###### 3. Re: Calculate Business Days only

Thank you. but the following worked:

(DATEDIFF('day',[Day1],[Day2]) -

(7-DATEPART('weekday',[Day1])) -

DATEPART('weekday',[Day2])

) / 7*5

+ MIN(5,(7-(DATEPART('weekday',[Day1]))))

+ MIN(5,(DATEPART('weekday',[Day2])-1))

-1