View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tjh tjh is offline
external usenet poster
 
Posts: 96
Default Formula for dates minus the weekends

I need help finding a formula that will figure out the days minus weekend days.

Ex: Due date Ship date #of days early # of days late
4/16/07 4/26/07 7

I would like for the # of days early or # of days late to give me a # BUT
not counting weekend days. Is there anyway to do this?
--
TJH