Date cell autofill another date cell

Noemi V · 02/28/24

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 · 02/28/24

Formula?

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

Noemi V · 02/28/24

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

CeliaC · 03/06/24

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?

Answers