Hi Emily,

Please copy and paste the follow in cell E1

=IF(D1<38717,"True","False")

After this is done, please copy cell E1 and paste in column E
throughout.

P.S: 38717 is the value corresponding to '12/31/2005 '

Thanks,
Yash

Emily wrote:
> Hi,
>
> I'll need to come up with a function that compares each value in column
> D with '12/31/2005 ' and return TRUE if the value in column D is
> smaller than '12/31/2005 ', but FALSE if it is greater than '12/31/2005
> '.
>
> I have the following formula:
>
> =(D1<'12/31/2005')
>
> But this gives me an error.
>
> Also I'l need to know how to apply this formula to other rows. Thanks!
>
> -Emily