I was right there up until the <=1, then I fell of the train.

Not sure why we're adding two dates together and subtracting 10. Seems like
we'd get something in the year 2118, but that's neither here nor there.

"David Biddulph" wrote:

Correct! You are not explaining it properly. Give us some examples of what
inputs should give what outputs from your formula, and why.
--
David Biddulph

"Kay" wrote in message
...
I have posted this so may times; maybe I am not explaining properly.

Start date March 23, 2006 (Cell K3)

July to June (D8:O8)

I have result D8+D9-10 (In D11) and I dragged this formula across to O11.

I want a formula that will over ride the month of march only L11 (with is
under the month of March) = or less than 1(=<1). This should be in
reference
to Month in K3.
--
KK