Calculating days

[yisfromer]

Hi,
I'm trying to get the sum of workdays between 2 given dates (A1 is the start date and B1 is the end date) with Saturday as the only non-workday (I'd like to exclude Saturday only)
I used Networkdays.intl in excel 2010 for this, but I have excel 2007 on my computer. How would I do it in Excel 2007?
Thank you!

 

[Jonmo1]

Welcome to the board.

Try

=SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,A1):INDEX(A:A,B1)))<>7))

 

[yisfromer]

Thank you, however, the function you gave me gives me the total difference of days and doesn't exclude saturdays at all.
example:
A1=18/11/2011
B1=22/11/2011
C1 (your function)=4

 

[Jonmo1]

There are 4 NON Saturdays between Nov18 and Nov22
Fri Nov 18
Sun Nov 20
Mon Nov 21
Tue Nov 22

I suppose the issue here is the definition of the word "Between"

Do you want to NOT include the beginning and/or ending dates?

 

[yisfromer]

Sorry, I realize now it is including both the beginning and end date.
Yes, I would like to exclude the beginning date and saturday in any count
so that in Nov 18 to Nov 22 it will count only nov 20, 21 and 22.
Thank you very much!

 

[Jonmo1]

To exclude the beginning date, try
=SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,A1+1):INDEX(A:A,B1)))<>7))

FYI, if you wanted to exclude the END date
=SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,A1):INDEX(A:A,B1-1)))<>7))

And logically, if you wanted to exclude both..

=SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,A1+1):INDEX(A:A,B1-1)))<>7))

 

[barry houdini]

This formula will also count non-Saturdays without the start date

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

format as general