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<>"",A2>TODAY(),A2<TODAY()+42),"Due","")

and copy down.

--

HTH

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


"natty" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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?