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?