On Sep 13, 4:22*pm, Ron Rosenfeld wrote:
On Tue, 13 Sep 2011 13:16:17 -0700 (PDT), BetaDocuments wrote:
I need a formula for today's date + 1 day (next business date). *But
if today is friday then I need the mondays date.

=workday(today(),1)

If this function gives you a #NAME error, and you are using a version of Excel prior to 2007, see HELP for the workday function for the fix.

Excellent!! It worked exactly the way I wanted :)