Forum Discussion
formula if in combination with working day
I am struggling with a formula. See photo: In column K I want the date to be one workingday after the last 'shootday' (column H, I or J). So: if there is just a date in column H, then 'workingday...
In kolom G:
=ALS([@[Shootdag 1 + grove selectie vlaggen]]=""; ""; WERKDAG([@[Shootdag 1 + grove selectie vlaggen]]; -2))
In kolom K:
=ALS([@[Shootdag 1 + grove selectie vlaggen]]=""; ""; WERKDAG(MAX(Tabel1214[@[Shootdag 1 + grove selectie vlaggen]:[Shootdag 3]]); 1))
Ik word steeds blijer! Fijn. Dank