Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How can i calculate networkdays between Monday to Saturday? is there any parameters?
Thanks.
Note : NetworkDays function calculates Monday to Friday.
You will need to use a work around... NetWorkDays is only for Monday to Friday
You will need to use a work around... NetWorkDays is only for Monday to Friday
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