View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Non working days

Put your dates in A1 and B1 and try this formatted as general

=DATEDIF(A1,B1,"d")-NETWORKDAYS(A1,B1)

Mike

"The Rook" wrote:

Is there a formula to calculate the number of non working days between 2
specific dates. For example:

01-01-07 to 31-01-07

No. of Saturdays = 4
No. of Sundays = 4

Cheers