Only WeekDays Count

[soha1902]

Hi All,

I am Having StartDate and FinishDate dimension. For using (FinishDate - StartDate) I am calculating the TotalDuration of a particular work.

See below:

As per my requirement I want to calculate only weekdays. For example Work(1) StartDate is 1/4/2010 means from Monday work was started and 1/7/2010(Wednesday) it was closed so its showing Total Duration =4 which is correct. Now for work(2), startdate was 1/5/2010(Tuesday) and CloseDate was 1/13/2010 (Wednesday) means 7(After excluding Weekends) but result was showing 9 which is not correct.

Please help.......

[Gysbert_Wassenaar · Accepted solution]

Use the networkdays function: networkdays( Start, Finish)

[#3]

Hi Soha,

As Gysbert says, you can use network days to calculate this, you also have a third parameter in this with the option of adding in holiday dates too, so these days are excluded from the calculation (just like weekend dates)

hope that helps

Joe

[saumyashah90]

=NetWorkDays(Start,Finish) this will surely work

1) NetWorkDays basically calculates all working days from the given dates .Removing Saturdays and Sundays.

2)Remember that it doesnt include public holidays.You may have to add public holidays externally.