Date Formula Help needed

  • Hi,

    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!