Thread: How to Calculate Dates without counting the weekends
View Single Post
  #2   Report Post  
Domenic
 
Posts: n/a
Default
In article ,
Lillian F <Lillian wrote:

I need the formula to calculate dates (Mondy to Friday) without counting the
weekends

You can use the NETWORKDAYS function...

=NETWORKDAYS(StartDate,EndDate,Holidays)

You'll need to enable the AnalysisToolpak...

Tools Add-Ins and check AnalysisToolpak.

Hope this helps!
Reply With QuoteReply With Quote