Counting dates but excluding weekends
 

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?

Counting dates but excluding weekends
 

Check out help on the WORKDAYS function.

Note that the Analysis Toolpak add-in must be loaded.


Gord Dibben MS Excel MVP

On Mon, 11 Aug 2008 17:04:06 -0700, Sara
wrote:

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?

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?

Counting dates but excluding weekends
 

Hi Sara

If you are not able to use the Analysis Toolpak function Workdays, as
already suggested, then you could use
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&A4)))<6))

--
Regards
Roger Govier

"Sara" wrote in message
...
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?