One way:

=if(and(date(2009,1,1)<=a1,a1<date(2009,4,1)),b1,0 )



comfuted wrote:

I want to test if a date is in first quarter, and if so, place value of a
cell into another. Otherwise, make it zero. A1 has date, column B1 has
value. In C1 I put:
=if(1/1/2009<=a1<4/1/2009,b1,0). This doesn't work, always says 0. What am I
doing wrong?
Thanks

--

Dave Peterson