Hello,

I'm not very proficient at Excel. Need some help. How would I go about 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 = Old else Column = New"

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

Thanks!

In E1 enter:

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

I have a bunch of dated forms and if its older then 01/08/2011 I need it to post Old or New if its newer then 01/08/2011.
_____
memory foam mattress | adjustable mattresses | memory pillow

Great!

Thanks,
Zoio