need formule

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

Find more posts tagged with

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.