B BetaDocuments Sep 13, 2011 #1 I need a formula for today's date + 1 day (next business date). But if today is friday then I need the mondays date.
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 Sep 13, 2011 #2 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. Click to expand... Your date in A1, then =WORKDAY(A1,1) Regards 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. Click to expand... Your date in A1, then =WORKDAY(A1,1) Regards Claus Busch
B BetaDocuments Sep 13, 2011 #3 =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. Click to expand... Excellent!! It worked exactly the way I wanted
=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. Click to expand... Excellent!! It worked exactly the way I wanted
