Networkdays Today + 1

B

BetaDocuments

I need a formula for today's date + 1 day (next business date). But
if today is friday then I need the mondays date.
 
C

Claus Busch

Am Tue, 13 Sep 2011 13:16:17 -0700 (PDT) schrieb BetaDocuments:
I need a formula for today's date + 1 day (next business date). But
if today is friday then I need the mondays date.

Your date in A1, then
=WORKDAY(A1,1)


Regards
Claus Busch
 
R

Ron Rosenfeld

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.
 
B

BetaDocuments

=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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top