# ARRAYFORMULA to calculate DATE that is one year later than the given date?

**URL:** <https://community.glideapps.com/t/arrayformula-to-calculate-date-that-is-one-year-later-than-the-given-date/22456>\
**Category:** Ask for Help\
**Created:** [February 9, 2021, 2:01am UTC](https://community.glideapps.com/t/arrayformula-to-calculate-date-that-is-one-year-later-than-the-given-date/22456 "2021-02-09T02:01:00Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 9, 2021, 2:15am UTC](https://community.glideapps.com/t/arrayformula-to-calculate-date-that-is-one-year-later-than-the-given-date/22456/3 "2021-02-09T02:15:28Z")

</div>

Check your quotes. When I copy/pasted your original, it contained “smart quotes”.

This works for me:

```auto
=ARRAYFORMULA(IF(D2:D<>"", DATE(YEAR(D2:D)+1,MONTH(D2:D),DAY(D2:D)), ""))

```

But regardless, much better to do this in the GDE (unless you actually need the data in the Google Sheet).

---

_[View the full topic](https://community.glideapps.com/t/arrayformula-to-calculate-date-that-is-one-year-later-than-the-given-date/22456)._