Date Formula help

D

Di

I am trying to calculate the number of days in a time period excluding
Sundays,
(i.e., 2/29/08 minus 2/23/08 = 5 )

Can anyone help me?

Thanks
 
T

T. Valko

(i.e., 2/29/08 minus 2/23/08 = 5 )

The correct result is 6.

A1 = 2/23/2008
B1 = 2/29/2008

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<7))
 
G

Gary''s Student

=B1-A1-SUM((WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(B1-A1)+1)))=1)*1)

This is an array formula and must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.
 
R

Ron Rosenfeld

I am trying to calculate the number of days in a time period excluding
Sundays,
(i.e., 2/29/08 minus 2/23/08 = 5 )

Can anyone help me?

Thanks
Click to expand...

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

will return a count of all the days from and INCLUDING A1 and A2 that are not
Sundays.

To exclude the starting date, merely subtract 1 from that value:

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

--ron
 
Top