One way (though there's got to be a better way):

Enter your start date (e.g., 10/1/2004) in E1. The total days in October
2004 will then be (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=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:

I need help with if statements.
I have two date columns - column A is date in fleet and column B is date out
of fleet. I want to find out how many fleet days I have in any given month.
Examples:
In Out #days in October'04
9/17/03 9/30/04 0
9/17/03 10/15/04 15
9/17/03 31 (where date out is blank)
11/30/04 3/31/05 0
11/30/04 0
10/5/04 27

Is it possible to do one if statement for two columns at once? I have tried
several times and keep getting "FALSE" for an answer.

Thanks!

Julie