Post Future date, skipping Sunday and Monday

[dakpluto]

I'm trying to setup a box that will display a future date for transactions. For the most part it's just "tomorrow's date" but =now()+1 won't work. Problem is, I need the future date to skip ahead 2 days when today is Sunday. As in the following:

Sun shows Tuesday date
Monday shows Tuesday date
Tuesday shows Wednesday date


etc etc

Thanks for any help you can provide.

[alansidman]

Try this:

=iif(Weekday(Date())=1,Date()+2,Date()+1)

[dakpluto]

Try this:

=iif(Weekday(Date())=1,Date()+2,Date()+1)

worked great! Thanks