View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cam Cam is offline
external usenet poster
 
Posts: 165
Default MDAY calculation

Hello,

Is there a way in Excel to calculate MDAY (date not including weekend)?

For example:
Ship date = 12/20/07,

I need a formula to calculated 25 days before ship date with weekend date
not counting (5 day a week). Thanks