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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <natty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:872FDBA3-7BC2-4774-A6F8-E5CBF2928A9A@xxxxxxxxxxxxxxxx
> 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?


.

Relevant Pages

  • can excel flagup in advance of a date, say 6 weeks
    ... i'm setting up a database, which states when training is needed. ... way for excel, or maybe another package, to flag up 6 weeks before the ...
    (microsoft.public.excel.misc)
  • Re: How do I create a macro with relative address?
    ... The flag you are after in Excel 2000 can be found in ... Donna ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Excel - Office XP
    ... Assuming you mean *.xls files, perhaps because they are read only when on ... Try copy to hd, ensure read only flag is off, then open within Excel ... Prev by Date: ...
    (microsoft.public.office.misc)
  • Access 2002 - getting started
    ... I have never used this package and now need to create a database of hundreds ... I have been asked to update one that has been provided to me using Excel. ... Which is the better package to use Access or Excel? ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • Re: Drop & Create Table - DTS Export to Excel
    ... Allan, ... That is to say that on the initial execution of the ... package, the data fell into place perfectly and as expected. ... if I open the Excel file and manualy delete all affected rows and ...
    (microsoft.public.sqlserver.dts)