I have a spread sheet that I want to change all of the
dates in column A to add 1 year and be listed in
column B. I used =A1 +DATE(1,1,1) and it works
as I am only showing Month and Year in the column
but the actual input is Month/Day/Year. Running on
Win xp system with Microsoft Excell for...