Get the date 5 networkdays from selected date

[D19PAL]

Hi,

I got a field with dates  for each date selected, u want to know what will be the date after 5 networkdays. 

Thanks

[Taoufiq_Zarra]

@D19PAL  you can use script or other

or you can for example use in UI:

=pick(Match(networkdays(DateRef,Date(DateRef+5)),5,4,3,1),
	Date(DateRef+5),
	Date(DateRef+6),
	Date(DateRef+7),
	Date(DateRef+8)
	)

output: