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
Bookmarks