Thanks for the info on the code tags.

The document may contain the last day of any month, but I would like it to always change whatever it finds to the last day of the previous month. For example, today is 12-3-13 and there is 2 documents in the folder. One says "May 31, 2013" and the other says "September 30, 2013", I'd like the macro to change these dates to November 30, 2013 (November 30th being the last day of the month prior today).