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

[Guest]

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?

 

[Bob Phillips]

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)

 

[KL]

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

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

Regards,
KL