Thanks Bob, but unfortunately, still no go.

"Bob Phillips" wrote:

Always best to stick to non-ambiguous dates

=IF(AND(C16=--"2007-07-01",C16<=--"2008-06-31"),E16,"")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Cbreze" wrote in message
...
Thanks for the fast response Mama, but that returned a #VALUE!

My cell values are as follows: c16 is 1/27/2008, E16 is 2,025.00; there
are
no formulas in those cells.

"Teethless mama" wrote:

=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