Date Formula

I have a worksheet in which I keep information about
students (i.e., name, grade, disability, birthdate,
evaluation date). Every 3 years each student must be re-
evaluted. What I would like is a formula that will put
the word "DUE in the appropriate column.

For example - I need to know all the evaluations that are
due when the current evaluation dates are before June 1,
2001.

PD,

With the date of the last evaluation date in A1

=IF(A1date(2001,6,1),"DUE","")

This will leave a blank if the evaluation is not due.

PC


"PD" wrote in message
...
I have a worksheet in which I keep information about
students (i.e., name, grade, disability, birthdate,
evaluation date). Every 3 years each student must be re-
evaluted. What I would like is a formula that will put
the word "DUE in the appropriate column.

For example - I need to know all the evaluations that are
due when the current evaluation dates are before June 1,
2001.