topic NetworkDays with Saturday in App Development

NetworkDays with Saturday

Anonymous — Fri, 25 Aug 2017 13:31:02 GMT

Hi All,

How can i calculate networkdays between Monday to Saturday? is there any parameters?

Thanks.

Note : NetworkDays function calculates Monday to Friday.

sunny_talwar — Fri, 25 Aug 2017 13:53:32 GMT

You will need to use a work around... NetWorkDays is only for Monday to Friday

Anonymous — Thu, 14 Sep 2017 09:30:36 GMT

Yes, i use awork around as;

If(Match(WeekDay(DATE),'Pzt','Sal','Çar','Per','Cum','Cmt'),'1','0') as [FlagNetWorkDays], //Short EN Days 'Mon','Tue','Wed','Thu','Fri','Sat'

If(Match(WeekDay(DATE),'Pzt','Sal','Çar','Per','Cum','Cmt'),'0','1') as [FlagSunday] //Short EN Days 'Mon','Tue','Wed','Thu','Fri','Sat'

Thank you