Setting WEEKDAY function to Exclude Friday in Calculation

[Guest]

I have to dates:
Cell A1 e.g 10/3/2004
Cell A2 e.g 22/9/2004
i want to calculate number of days between the two dates excluding Friday.

Note: i am using Office XP 2002

 

[Frank Kabel]

Hi
try:

 

[Guest]

Thanks for your reply,
the result is different if you apply it the formula to:
A1 = 1/9/2004
a2 = 30/9/2004

Faizan

Hi
try:

 

[Frank kabel]

Hi
sorry, wrong weeknumber exclusion. Make this:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<>6))

This returns 26 for your example set of dates

-----Original Message-----
Thanks for your reply,
the result is different if you apply it the formula to:
A1 = 1/9/2004
a2 = 30/9/2004

Faizan

 

[Guest]

Dear Frand Kabel,
Thank you very much for comments,
it really solved my problems.

thanks
Faizan