View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
Posts: 1,045
Default Networkdays Today + 1

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.