How can I edit the year in a date field in Excel?
 

I have column in Excel that is formated as for dates. I need to change just
the year.

How can I edit the year in a date field in Excel?
 

Hi David,

you can use find and replace, or, send us more information

regards
from Brazil
Marcelo

"David Denham" escreveu:

I have column in Excel that is formated as for dates. I need to change just
the year.

How can I edit the year in a date field in Excel?
 

Hello David,

to add a year to a given date in A1 use

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

Regards,
Ingolf



David Denham schrieb:

I have column in Excel that is formated as for dates. I need to change just
the year.