View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Networkdays Today + 1

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2