I would like a macro to automatically run if the date is
anywhere in a given 8 week period. For example, if the
date is greater then October 1, I would like the macro to
run and I only want it to run once.

The code I have put in place is:

If Date=October1 then
Sheets("FORECAST").Select
Range("AA8:AA44").Select
Selection.Copy
Range("Z8:Z44").Select
Selection.PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1:A3").Select
Application.CutCopyMode = False
Else End

Can someone review and let me know if this is right. Also,
how do I only get it to run once?