Less Than Greater Than Date Question
 

I need to put in a formula that simply says if a date in a cell is less than
a particular specified date. I'm fairly good with Excel, but I can't figure
this out. Major brain freeze, I'm sure.

Let's say A1 has 1/31/2005 in it. In B1 (and copy/pasted all the way down),
I want to show if A1, A2, A3, etc. is less than or equal to 1/1/2006. So, in
this case, B1 would show "YES".

Thoughts?

Less Than Greater Than Date Question
 

=if(A1<date(2006,1,1),"Yes","No")
--
http://HelpExcel.com




"Paperback Writer" wrote:

I need to put in a formula that simply says if a date in a cell is less than
a particular specified date. I'm fairly good with Excel, but I can't figure
this out. Major brain freeze, I'm sure.

Let's say A1 has 1/31/2005 in it. In B1 (and copy/pasted all the way down),
I want to show if A1, A2, A3, etc. is less than or equal to 1/1/2006. So, in
this case, B1 would show "YES".

Thoughts?