Forgot an = sign:

=SUM(IF(B2:B7="", DATE(YEAR(E1),MONTH(E1)+1,1), IF(B2:B7<=E1,E1,
IF(B2:B7DATE(YEAR(E1),MONTH(E1)+1,1), DATE(YEAR(E1),MONTH(E1)+1,1),
B2:B7+1))), -IF(A2:A7<E1, E1, IF(A2:A7DATE(YEAR(E1), MONTH(E1)+1,1),
DATE(YEAR(E1),MONTH(E1)+1,1), A2:A7)))

In article ,
Julieeeee wrote:

Please ignore my last reply. I meant to say your formula works except for:

INF OOF 10/01/04
05/14/04 11/01/04 32
10/02/04 01/19/05 30
10/21/04 11

In the above example only the first one is wrong - that should read 31 days,
not 32. Can you tweak the formula to calculate that correctly?