Posts by Johnwallworth


    I have been going in circles with this.

    I have two cells,

    F3 and G3

    They are part of a row that automatically enter dates based on a lookup table, and using weekday I can get that bit to work.

    However, G3 has to always be on a Wednesday.

    An example would be F3 contains 09/01/18, G3 allows(x) working days so in this example of 5 working days would show a date of 16/01/18 but this needs to be a Wednesday. To add to the confusion the Wednesday it receives must be the next Wednesday it can never round down. The amounf of days added is variable based on a drop down option earlier on in the row.

    My lookup table shows how many working days and its reference is O3 so my formula is =IF(f3="","",WORKDAY(F3,03))

    like I say what I am trying to do is get this cell to always be the next Wednesday, and never round down.

    Any help would be appreciated.