Date cell autofill another date cell

Noemi V

Can a date cell autofill another date cell with the date 1 yr in the future? ex 2/21/2024 autofills to 2/21/2025

CeliaC

Formula?

datePlusAyear=DATE(YEAR(date)+1, MONTH(date) + 1, DAY(date))

Noemi V

Thank you! I've been trying to add the formula but I keep receiving an unparseable note

CeliaC

Hey,

I made a mistake in the previous answer - there shouldn't be a "+1" in the month.

Updated formula:

datePlusAyear=DATE(YEAR(date)+1, MONTH(date) , DAY(date))

For the unparseable note, make sure both columns are Date columns?