Return numbers of days from a day

[worthmw]

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

[jeffreybrown]

Maybe something like...

=IF(OR(WEEKDAY(TODAY(),2)={1,2,3}),TODAY()+1,IF(OR(WEEKDAY(TODAY(),2)={4,5}),TODAY()+4,""))

[worthmw]

Wow, that works! Thank you very much!

[jeffreybrown]

You're welcome. Glad it helped!