number of week days in a period of time

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.
 
J

Jacob Skaria

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
 
E

Erol

THanks all,

I use MS Office 2000 so the long formula worked only with me. Thanks again
 
T

T. Valko

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

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

Month days over a time period 5
number or working days 6
formulas to count dates 2
Count cells with a date falling within a 30 day period. 2
Need formular to use with dates 7
How do I get the week in month from a date? 2
allocate resource over long period of time 0
Weekending Date w/Less Than 3 days Assoc. with Prior Month 7

Top