Excel - Less Than Greater Than Date Question

Asked By PaperbackWrite on 22-Jan-07 02:41 PM
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?




e replied on 22-Jan-07 02:47 PM
=if(A1<date(2006,1,1),"Yes","No")
--
http://HelpExcel.com
ed@helpExcel.com