# Formula required - Dates and If Formulas??

#### Hannah1987

##### New Member
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.

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
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}))

Last edited:
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?

Try this one...

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

Thanks again Barry,
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.

Replies
4
Views
162
Replies
7
Views
248
Replies
1
Views
149
Replies
4
Views
212
Replies
10
Views
379

1,203,140
Messages
6,053,729
Members
444,681
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back