Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Please check enclosed file...
Thank you this working fine