=IF(AND(C16=--"7/1/2007",C16<=--"6/31/2008"),E16,"")

"Cbreze" wrote:

This seemed simple. I need to determine if a date is in the fiscal year, and
if so, show data in a seperate column. (i.e. if a date in column a is
between x and y, show the amount in column b in column c, or if no, show
nothing)

I thought this would work, but no go.

=IF(AND(C16=7/1/2007,C16<=6/31/2008),E16,"")

Where did I go wrong?

Thanks