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.

Hi,
try

=NETWORKDAYS(D9,E9)

change range to fit your needs

"Erol" wrote:

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.

Look in HELP for the NETWORKDAYS() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Erol" wrote in message
...
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
---------------
Jacob Skaria


"Erol" wrote:

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.

THanks all,

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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Erol" wrote:

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.

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

--
Biff
Microsoft Excel MVP


"Erol" wrote in message
...
THanks all,

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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Erol" wrote:

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.