How to add year in date in excel?

📊 Adding Year to a Date in Excel

1. Suppose your date is in cell A1.
2. Use formula:
   =DATE(YEAR(A1)+1, MONTH(A1), DAY(A1)) (replace +1 with the number of years to add)
3. Press Enter, and the new date with updated year appears.

Tip: For bulk update, drag the formula down the column.