ExcelBanter - Calculating Turn Around Times excluding Sunday

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calculating Turn Around Times excluding Sunday (https://www.excelbanter.com/excel-worksheet-functions/264085-calculating-turn-around-times-excluding-sunday.html)

ls111248

Calculating Turn Around Times excluding Sunday

I need to track turn-around-times, date & time, excluding Sunday. The end
result needs to be the number of dates to completion. In this case the result
should be 4.25.
What I have currently is:
D76 E76 has Formula F76
Date Started Date Completed Number of Days to
Complete
5/12/2010 8:00 AM 5/17/2010 14:00 PM =IF(E76-D76<=0,"",E76-D76)

The formula I'm using does not exclude Sunday. I also receive a #VALUE
error when E76 is empty if I try to add -1 to the formula. (I'm using Excel
2007)

bala_vb

Quote:

Originally Posted by ls111248 (Post 954572)

try this formula
=IF(E76-D76<=0,"",(E76-D76)-(WEEKNUM(E76)-WEEKNUM(D76)))

all the best

Teethless mama

Calculating Turn Around Times excluding Sunday

A2: Start date
B2: Complete date

=IF(COUNT(A2:B2),SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(INT(A2)&":"&INT(B2))))1))-1+MOD(B2,1)-MOD(A2,1),"")

"ls111248" wrote:

I need to track turn-around-times, date & time, excluding Sunday. The end
result needs to be the number of dates to completion. In this case the result
should be 4.25.
What I have currently is:
D76 E76 has Formula F76
Date Started Date Completed Number of Days to
Complete
5/12/2010 8:00 AM 5/17/2010 14:00 PM =IF(E76-D76<=0,"",E76-D76)

The formula I'm using does not exclude Sunday. I also receive a #VALUE
error when E76 is empty if I try to add -1 to the formula. (I'm using Excel
2007)

All times are GMT +1. The time now is 10:39 PM.