Setting WEEKDAY function to Exclude Friday in Calculation
 

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
--
Faizan Ahmad

Setting WEEKDAY function to Exclude Friday in Calculation
 

Hi
try:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<5))

-----Original Message-----
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
--
Faizan Ahmad
.

Setting WEEKDAY function to Exclude Friday in Calculation
 

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

Faizan
"Frank Kabel" wrote:

Hi
try:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<5))

-----Original Message-----
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
--
Faizan Ahmad
.

Setting WEEKDAY function to Exclude Friday in Calculation
 

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
"Frank Kabel" wrote:

Hi
try:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<5))

-----Original Message-----
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
--
Faizan Ahmad
.


.

Setting WEEKDAY function to Exclude Friday in Calculation
 

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

thanks
Faizan

"Frank kabel" wrote:

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
"Frank Kabel" wrote:

Hi
try:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<5))

-----Original Message-----
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
--
Faizan Ahmad
.


.