Condition

E

Erlang

I have a column A with dates. If the date on that column is less than
08/01/2008, on column B I want it to state "N". How do I accomplish
this?
 
K

Ken Johnson

I have a column A with dates. If the date on that column is less than
08/01/2008, on column B I want it to state "N". How do I accomplish
this?
Click to expand...

=IF(ISNUMBER(A1),IF(A1<DATE(2008,1,8),"N",""),"") for 8th Jan 2008
=IF(ISNUMBER(A1),IF(A1<DATE(2008,8,1),"N",""),"") for 1st Aug 2008

Ken Johnson
 
Top