I want to take/copy/whatever? the date from a particular cell in the format
DD-MMM-YYYY, from there I want to format that date into MMM-YY into another
cell. After that has been complete, take that formatted date and auto fill 6
more columns with the past 6 months.

Another way to look at it:

(Take Cell A1) 18-JUN-2008 (Format Cell D1 like this) JUN-2008 (Then
auto fill F1:L1)JUN-2008 to JAN-2008

Please help.