View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default MDAY calculation

See WORKDAY() in XL Help.

In article ,
Cam wrote:

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