ExcelBanter - Condition

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Condition (https://www.excelbanter.com/excel-discussion-misc-queries/195881-condition.html)

Erlang

Condition

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?

daddylonglegs

Condition

I assume you mean 1st August? for B2 try

=IF(A1<DATE(2008,8,1),"N","")

"Erlang" wrote:

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?

Ken Johnson

Condition

On Jul 23, 9:16 am, Erlang wrote:
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?

=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

All times are GMT +1. The time now is 06:18 PM.