View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs
 
Posts: n/a
Default Removing Weekend dates from Day Calculations


If your invoices always go out on weekdays your 5 days grace will be the
equivalent of 7 actual days, won't it?

...unless you want to factor in holidays, in which case I believe you'd
want NETWORKDAYs as suggested by JE McGimpsey


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