Counting dates but excluding weekends

S

Sara

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?
 
G

Gord Dibben

Check out help on the WORKDAYS function.

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


Gord Dibben MS Excel MVP
 
R

Roger Govier

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
formulas to count dates 2
Count partial dates 1
Count days between two dates excluding weekends 2
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
Calculate next workday after adding calendar days to date in cell 13
Conditional Formatting - Given dates within certain range of days 4
Exclude Weekends 4

Top