Excel IF Statement

I am new at IF statements.  I have a date in one cell (C2), example 5/20/2011.  I want my IF statement to read, IF C2 is less than today's date return text of Past, IF C2 is greater than today's date return text of Present.

Ulimately I have 1011 rows of data & I need to quickly be able to see which are past appointments and which are future appointments.
mltardifAsked:
Who is Participating?
 
jimyXConnect With a Mentor Commented:
In C3 put:
=IF(C2>=TODAY(),"present","past")

And copy down.
0
 
jimponderCommented:
=IF(C2<(TODAY()),"PAST","")
0
 
nidashCommented:
the formula would be cell d1 and would look like

=IF(C1<TODAY(),"PAST","PRESENT")

then copy across the formulas to all rows, finally manage visibility using autofilter where you can choose 'PAST'or "PRESENT'to look at what you want quickly.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
mltardifAuthor Commented:
Thanks so much!!!
0
 
jimponderCommented:
I get in first and don't get credit... nice.
0
 
mltardifAuthor Commented:
Sorry but yours was a little confusing, the other one was idiot proof.
0
 
mltardifAuthor Commented:
And this person thought to add > = which I never even thought of.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.