Formula for =Today() logic

[dmill8023]

Hello All! I am looking for help with logic for a formula.

I am looking to do formulas for =Today()+1 for all days except Saturday - on Saturday I need it to be =Today()+2.

I'm guessing this can be done by building an if statement with weekday and today built in the statement but I need some assistance with the logic.

Any suggestions would be greatly appreciated.

 

[Joe4]

Try:

=IF(WEEKDAY(TODAY())=7,TODAY()+2,TODAY()+1)

 

[dmill8023]

Perfect, thanks Joe4! I actually came up with the exact formula a minute ago but it is nice to see we're on the same page!

Thanks!

 

[barry houdini]

This is the equivalent of finding the next working day when your "weekend" is Sunday only. You can do that with WORKDAY.INTL function (excel 2010 or later), I.e.

=WORKDAY.INTL(TODAY(),1,11)

11 indicates Sunday only as weekend. If you want you can exclude holidays too