Date Diff Issue

[svsudhakar]

Hi ,

I got one requirement like I have to find out how many days has taken for completing the one task. it's having starting and ending dates. But while calculating the date differences I should not consider the weekend(Saturday and Sunday) and Govt holidays.

Kindly suggest on this how can I process.

I have to implement the same date diff logic with more than 10 different fileds.

[jonathandienst · Accepted solution]

Hi

Use this which will handle weekends:

NetWorkDays(startdate, enddate)

Load holidays into a quoted,comma separated list in a variable (eg vHolidays = '2014/01/01', '2014/03/21') and use to handle all non-working days:

NetWorkDays(startdate, enddate, $(vHolidays))

Or use a working day flag in a master calendar and sum the flag values to get the number of working days.

HTH

Jonathan

[MK_QSL]

Please check enclosed file...

[svsudhakar]

Thank you this working fine