I am looking at showing the quarter a selective date is in i.e. 9-Dec-09
would be 4Qtr09.s Any code that can do this without having to go in to do it
manually? The amount of data in the column is also constantly changing so I
would need the code to loop until the end of the data. Any help would be
appreciated.

Date Quarter
9-Dec-09 4Qtr09
1-Jan-10 1Qtr10

The data in these columns are generated using a macro and will not always
have the same number of rows.