Formula required - Dates and If Formulas??

[Hannah1987]

Hello all,
I am looking to do a spreadsheet which will have cut off days on it.
What I would like done is for it to give the next available date for a product basing it on today's date which will be in A1.
My issue is that we have a product which has a cut off on a Monday and a Wednesday and I would like it to look at the date it currently is using this formula =TODAY() in A1 and then decipher the next cut off whether it be Monday or Wednesday and show the date in a separate cell.
Can someone please let me know which formula would be best here?
Thank you.

 

[barry houdini]

Hello Hannah1987, welcome to MrExcel

If today is a Monday should the result be the Wednesday? If so try this formula

=CHOOSE(WEEKDAY(A1),1,2,1,5,4,3,2)+A1

....or for the same results

=MIN(A1+8-WEEKDAY(A1+{4,6}))

 

[Hannah1987]

That's awesome, thank you.
I should have mentioned that I did also want it to choose the same day if it was a Monday then it should select that day too until the date in A1 changes to Tuesday then it will jump to the Wednesday and so on, it there are way of changing this?

 

[barry houdini]

Try this one...

=MIN(A1+7-WEEKDAY(A1+{3,5}))

 

[Hannah1987]

Thanks again Barry,
You have been very helpful.
Once more question, if it is not too much trouble.
If I have your new formula in a cell and would like a cell to give me the date of the next Thursday (if the previous cell is Monday) or the next Monday (if the previous cell is a Wednesday).
I hope this helps. Just trying to show the lead time for the goods to be manufactured based on the day of cut off.