try naming two cells as "start" and "end" and entering your start and end
date of interest. format these cells as dates
entering in your coulumn of interest
=min(0,if(or(out="",outend),end,out)-max(start,in)


"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