Thread: How can I edit the year in a date field in Excel?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ingolf Ingolf is offline
external usenet poster
  
Posts: 32
Default 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.

Reply With QuoteReply With Quote