Hi,
use

=IF(AND(B1DATE(2008,12,31),B1<DATE(2010,1,1)),A1, "")


"Rob" wrote:

This has worked fine, but is their any way i can just have the values where
this argument is applicable instead of 0 when it doesn't

"Jacob Skaria" wrote:

In cell A1 and copy down as required
=IF(AND(B1DATE(2008,12,31),B1<DATE(2010,1,1)),A1, 0)

If this post helps click Yes
---------------
Jacob Skaria


"Rob" wrote:

I am trying to return the values of column Ain column C if the dates in
column B are between 31/12/2008 and 01/01/2010

Column A Column B Column C
1040 24/12/2008 1042
1042 03/01/2009 1041
1041 21/06/2009 1043
1043 21/12/2009
1045 03/01/2010

Have tried =IF(AND(B:B31/12/2008,B:B<01/01/2010),A:A,0)