Hello I am using Office 2007.

Here is what I need the formula to do:

If today is Thursday, show the date for the following Monday (as in 8/28/17)

If today is Friday, show the date for the following Tuesday (as in 8/29/17)

If today is Monday or Tuesday or Wednesday, add one to today's date and display tomorrow's date

Here is the formula I'm using but it's not right

=if(or(weekday(today() =4), (weekday(today()=5), today()+4,today()+1)))


What am I doing wrong? Thanks for your help in advance