In Excel, change only year component to date

Question

How to change only the year component of a date using Excel formulas?

example: 12/31/07 → 12/31/11

Answer 1

Use (for example)

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

Answer 2

The general way to do this is:

=DATE(2011, MONTH(A1), DAY(A1))

Answer 3

, 12/31/07 A1

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

Answer 4

, , Home Ribbon, 2010 (, ) 2013 (, ) " /" " ", .

Answer 5

Int (A1) -