Excel help needed - update row of dates to 2012

[Jaynerae]

I have a several workbooks, that contain several spreadsheets in excel, and they have the date for the year across the top. I need to update them from 2011 to 2012. They have weekends and formulae columns between the months, so I can not just fill series. Is there a quick way to do this?, otherwise I am going to have to do each month seperately, I really haven't got time to do it that way.

any one any ideas?

Presumably a simple Replace '2011' with '2012' won't work because it will throw the weekends?

It's not totally clear what you've got, can you upload it to YouSendIt or similar? Or my web site (delete any sensitive data if you want).

Scroll down and continue the series. Then cut and paste the future dates where you want them using the 'paste special' function.

The other thing you can do is add 365 to the old dates (and insert Feb 29)