If Statements with Dates
It might be easier, if this is something you do often with different dates,
to enter the date you want to check against in a cell. If 9/15/06 is in cell
D1, then
=if(B65$D$1,"True","") works as well. Then you can change the date in cell
D1 at anytime without having to re-enter the formula.
"Erika" wrote:
I am trying to build a If statement using dates, I am getting all True the
forumla I have built is =IF(B659/15/06,"true","") B65=9/1/06
What am I doing wrong?
|