View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Infinitogool Infinitogool is offline
external usenet poster
 
Posts: 52
Default Counting dates but excluding weekends

Hi Sara
Try:
=NETWORKDAYS(A2,A4)

Regards,
Pedro J.

Is there a function to count the difference of days, but to exclude the
weekend?

For example, Cell A2 has the date Monday, August 11, 2008 and cell A4 has
the date Tuesday, August 19, 2008

What would the function be to count the number of days in between?