--
Farhad Hodjat


IF(E14="1/31/2008",0,IF(AND(e14<"1/31/2008",e14"1/14/2007"),L14/12,IF(AND(e14<"1/15/2008",e14"12/31/2007"),L14/24,"")))

i think this should be the correct syntax just put what you want instead ""
that i put in your if chains.

Thanks,
"Micki" wrote:

Cell E14 contains a date and I want certain things to happen if the date is
equal to certain criteria. I'm having problems with the syntax.
IF(E14="1/31/2008",0,if(AND(e14<"1/31/2008",e14"1/14/2007",L14/12,if(AND(e14<"1/15/2008",e14"12/31/2007",L14/24)))))

Thank you.