Calculate duration: monday - friday

Joseph Aloysias

I have set the working days as Monday to Sunday as 7 days calendar. and I want to calculate and I would like to calculate days (Monday to Friday) count in the a duration column (created another duration column other than project setting column)

I tried this formula - =IFERROR(IF(Calendar@row = "7 Days", NETDAYS([Actual Start Date]@row, [Actual End Date]@row), NETWORKDAYS([Actual Start Date]@row, [Actual End Date]@row)), 0)

Based on the calendar days selection it should calculate the actual duration, Please help!

Mike TV

@Domnic Victor

It looks to be working to me.

Joseph Aloysias

Is there any formula to calculate Monday, Tuesday, Wednesday, Thursday, Friday? because the networkdays function calculate based on the project settings work days.

Joseph Aloysias

@Paul Newcome @Genevieve P. Is there any formula to calculate Monday, Tuesday, Wednesday, Thursday, Friday? because the networkdays function calculate based on the project settings work days (which I have set to Sunday to Monday).

Genevieve P.

Hi @Domnic Victor

You're correct, if you have Dependencies enabled then the NETWORKDAYS function will calculate working days based on your Project Setting working days.

I would suggest doing the opposite: set your Working Days to be M-Fr in Project Settings so you can use the NETWORKDAYS function to calculate a M-Fr week, then use elapsed time in your actual Duration column if you want to indicate a working weekend (Sat / Sun).

Cheers,

Genevieve

Joseph Aloysias

@Genevieve P. if I use elapsed time its adding one additional day to the end date, Is there a way to calculate the correct duration and end date?