Thread: Date Calculation to exclude weekends
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Date Calculation to exclude weekends

If you have Analysis ToolPak installed you can use NETWORKDAYS, e.g.

=NETWORKDAYS(A1,B1) where your first date is in A1 and second date in
B1


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=504437

Reply With QuoteReply With Quote