need formule

TVP ALAN

hallo

can you help me with a formule

in column WK needs to be filled in the week linked with colomn date , So when in cell action is 3OUT the cell in column WK needs to be filled in on the info mentioned in date out but in week format.+ 1 WEEK

so in this example goods aout on day 18/04 = WK 16 so result must be in WK cell 17

when action is 1IN en 2Picking the Cell in WK colomn the cell must be filled in as this is

So 18/04 is WK 16 info in cell colomn WK = 16

Hope this is clear

Gillian C

Hi @TVP ALAN

What about trying

=IF(Action@row = "3OUT", WEEKNUMBER([Date out]@row) + 1, IF(OR(Action@row = "1IN", Action@row = "1PICKING"), WEEKNUMBER([Date in]@row)))

This is basically a nested IF formula that says if 'Action' equals "3OUT" then the WK number is the Wk number in "Date out" + 1, else if the Action is "1IN" or "1PICKING" it is the weeknumber from Date in?