number of week days in a period of time

  • Thread starter Thread starter Erol
  • Start date Start date
E

Erol

Hi All,

How do I count number of week days between to dates? (ex: one cell date is 1
July 2009, the other cell has a value of 30 July 2009... if I count manually
it seems like there are 20-21 week days)

I appreciate any input. Thanks in advance.
 
With start date in A1 and end date in B1 the below formula will give you the
number of working days inclusive of both dates...

=(B1-WEEKDAY(B1,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY(A1,2))+MIN(5,WEEKDAY(B1,2))+1

If this post helps click Yes
 
Here's one that's a bit shorter (just don't ask me how it works!):

To count the weekdays Monday through Friday between 2 dates (inclusive):

=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7))
 
Back
Top