Date Formula

  • Thread starter Thread starter PD
  • Start date Start date
P

PD

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(A1<date(2001,6,1),"DUE","")

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

PC
 
Back
Top