Find Every Tuesday or Thursday

Try it this way in K32:

=IF($I$14="Yes",K31+IF(WEEKDAY(K31,2)=2,2,5),K31+7)

Assumes the starting date is in K31, and that it will only be either a Tuesday or a Thursday date.

Format the cell as a date, then copy down as far as required.

Hope this helps.

Pete

Glad to hear it - thanks for the feedback.

Pete

Do you have a list of your holidays in a range somewhere? It might be easier to still show the Tuesday/Thursday dates for the rest of the year, but to indicate that a particular date is a holiday, maybe by conditional formatting, i.e. if the cell is one of the dates in the holiday list then colour it red (or something like that). If you want to do this then you can highlight all the cells with the dates in, from K31 to whatever, then click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the dialogue box:

=ISNUMBER(MATCH(K31,holiday_list,0))

where holiday_list is the range where your holidays can be found, then click the Format button | Fill tab and choose your colour, then click OK twice to exit - Excel will automatically adjust the cell references to suit the cells that are selected.

Hope this helps.

Pete

Actually, instead of a red background it might be better to use a white foreground, so the Tuesdays or Thursdays which are holidays are still there, but they appear to be blank.

Hope this helps.

Pete