NetworkDays with Saturday

[Anonymous]

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 · Accepted solution]

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

[Anonymous]

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