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

's Computer Specifications

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

's Computer Specifications

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.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert number field with year value to date field	LVer	Microsoft Access	1	5th May 2008 03:42 PM
Procedure to update a DATE field to either a year from now or a year from what is in the field?	Andrew	Microsoft Excel Programming	7	15th Jan 2008 01:02 PM
Converting a date field into a month-year only field	=?Utf-8?B?Qy5IaXJzY2g=?=	Microsoft Excel Misc	1	25th Apr 2006 12:08 AM
year of date field is same as year of today	=?Utf-8?B?RGF0YWJhc2UgVXNlcg==?=	Microsoft Access Queries	2	28th Jul 2005 12:52 PM
Jpw do I capture the year from a date field in a separate field f.	=?Utf-8?B?Ym9uZXM=?=	Microsoft Access Forms	2	21st Aug 2004 07:07 PM