I have to calculate the no of days between 2 dates and exclude only sundays
in my count of days. I have tried NETWORKDAYS but it seems to exclude
saturdays and sundays. I only need to exclude sundays. Can somebody help me?

Thanks
Danielle

=SUMPRODUCT(--(WEEKDAY(A2:A20)<1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"danh" wrote in message
...
I have to calculate the no of days between 2 dates and exclude only sundays
in my count of days. I have tried NETWORKDAYS but it seems to exclude
saturdays and sundays. I only need to exclude sundays. Can somebody help
me?

Thanks
Danielle

If you want to plug the dates into cells and use those in the formula, use

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(start_date&":"&end_date)))< 1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"danh" wrote in message
...
I have to calculate the no of days between 2 dates and exclude only sundays
in my count of days. I have tried NETWORKDAYS but it seems to exclude
saturdays and sundays. I only need to exclude sundays. Can somebody help
me?

Thanks
Danielle

Hi Bob,

Thanks for your help. I tried it but I think I am not using it correctly.
If I have 2 dates for example the 3 April 07 and 30 March 07 and I have to
find out the no. of working days between these 2 dates excluding sundays. My
answer should be 4 which is 3 April - 30 March = 5 days - 1 sunday = 4
working days.

Can you explain to me how I should use SUMPRODUCT with my example.

Thanks,
Danielle

"Bob Phillips" wrote:

=SUMPRODUCT(--(WEEKDAY(A2:A20)<1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"danh" wrote in message
...
I have to calculate the no of days between 2 dates and exclude only sundays
in my count of days. I have tried NETWORKDAYS but it seems to exclude
saturdays and sundays. I only need to exclude sundays. Can somebody help
me?

Thanks
Danielle

Did you see my second post?

Using this, either put 30 March 07 in one cell and 3 April 07 in another and
reference those like so

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))<1))

or cut the dates into the forumla directly

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(--"2007-03-30"&":"&--"2007-04-03")))<1))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"danh" wrote in message
...
Hi Bob,

Thanks for your help. I tried it but I think I am not using it correctly.
If I have 2 dates for example the 3 April 07 and 30 March 07 and I have
to
find out the no. of working days between these 2 dates excluding sundays.
My
answer should be 4 which is 3 April - 30 March = 5 days - 1 sunday = 4
working days.

Can you explain to me how I should use SUMPRODUCT with my example.

Thanks,
Danielle

"Bob Phillips" wrote:

=SUMPRODUCT(--(WEEKDAY(A2:A20)<1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"danh" wrote in message
...
I have to calculate the no of days between 2 dates and exclude only
sundays
in my count of days. I have tried NETWORKDAYS but it seems to exclude
saturdays and sundays. I only need to exclude sundays. Can somebody
help
me?

Thanks
Danielle

Thank you so much for your help. I will try these.

"Bob Phillips" wrote:

If you want to plug the dates into cells and use those in the formula, use

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(start_date&":"&end_date)))< 1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"danh" wrote in message
...
I have to calculate the no of days between 2 dates and exclude only sundays
in my count of days. I have tried NETWORKDAYS but it seems to exclude
saturdays and sundays. I only need to exclude sundays. Can somebody help
me?

Thanks
Danielle

With start date in A1 and end date in B1 this formula will give you the
number of non-Sundays between those dates

=B1-A1-INT((1-WEEKDAY(B1)+B1-A1)/7)

format as general


"danh" wrote:

Thank you so much for your help. I will try these.

"Bob Phillips" wrote:

If you want to plug the dates into cells and use those in the formula, use

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(start_date&":"&end_date)))< 1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"danh" wrote in message
...
I have to calculate the no of days between 2 dates and exclude only sundays
in my count of days. I have tried NETWORKDAYS but it seems to exclude
saturdays and sundays. I only need to exclude sundays. Can somebody help
me?

Thanks
Danielle