I have column in Excel that is formated as for dates. I need to change just the year.
D David Denham Jul 14, 2006 #1 I have column in Excel that is formated as for dates. I need to change just the year.
M Marcelo Jul 14, 2006 #2 Hi David, you can use find and replace, or, send us more information regards from Brazil Marcelo "David Denham" escreveu:
Hi David, you can use find and replace, or, send us more information regards from Brazil Marcelo "David Denham" escreveu:
I Ingolf Jul 14, 2006 #3 Hello David, to add a year to a given date in A1 use =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) Regards, Ingolf
Hello David, to add a year to a given date in A1 use =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) Regards, Ingolf
