can excel flagup in advance of a date, say 6 weeks
 

i'm setting up a database, which states when training is needed. is there a
way for excel, or maybe another package, to flag up 6 weeks before the
training due date?

You can use a formula, so say the training dates are in column A. In say
column M, add a formula of say

=IF(AND(A2<"",A2TODAY(),A2<TODAY()+42),"Due","")

and copy down.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"natty" wrote in message
...
i'm setting up a database, which states when training is needed. is there
a
way for excel, or maybe another package, to flag up 6 weeks before the
training due date?

You can use Conditional Formatting of a cell with a formula like this:

=TODAY()=DATE(2005,8,24)-42

Regards,
KL


"natty" wrote in message
...
i'm setting up a database, which states when training is needed. is there
a
way for excel, or maybe another package, to flag up 6 weeks before the
training due date?