If then Statement for Excel Columns

[zoio]

Hello,

I'm not very proficient at Excel. Need some help. How would I go abou
making a if then statement for 2 rows.

I would like something like this.

"If dates in Column K is less than 01/08/2011 --> then Column E = Ol
else Column = New"

I have a bunch of dated forms and if its older then 01/08/2011 I need i
to post Old or New if its newer then 01/08/2011.

Thanks

 

[James Ravenswood]

In E1 enter:

=IF(K1<DATEVALUE("1/8/2011"),"Old","New")
and copy down

 

[zoio]

Great!

Thanks,
Zoio

In E1 enter:

=IF(K1<DATEVALUE("1/8/2011"),"Old","New")
and copy dow