Date Formula

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.
 
P

Paul Corrado

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top