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