Chris Hankin,
You can find some tutorials on advanced filter at
http://www.contextures.com/xladvfilter01.html
HTH
Cecil

"Chris Hankin" wrote in message
...
Hello,

Could someone please help me with the following:

I need to run a macro that lets the user know when a date has been on the
spreadsheet for exactly 14-calendar days.

The dates are in Column D of my spreadsheet named: AOG_UNDA Database. The
column header is named: Date Demanded.

77AVMF 0848
04
UNDA
04 Jun 2004
BATTERY STORAGE
66-090-1903
86Z
4
0
BMF

77AVMF 0849
04
UNDA
04 Jun 2004
CASE & VALVE ASSEMBLY
01-428-8889
904-002-786
35
0
OXY

77AVMF 0850
04
UNDA
09 Jun 2004
ELECTRON TUBE
01-269-5704
34-056085-02
1
0
EW



Shown above is a small portion of my spreadsheet. Column AF is the last
column on my spreadsheet.

I need to PrintPreview the output.

The macro needs to run once per day. So when the user opens up the
spreadsheet each day the macro needs to automatically run on start-up.

Any help would be greatly appreciated.

Kind regards,

Chris.