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?