# Customer to input a date to generate a list relative dates

**URL:** <https://community.glideapps.com/t/customer-to-input-a-date-to-generate-a-list-relative-dates/22642>\
**Category:** Ask for Help\
**Created:** [February 11, 2021, 11:26pm UTC](https://community.glideapps.com/t/customer-to-input-a-date-to-generate-a-list-relative-dates/22642 "2021-02-11T23:26:58Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\
**Post date:** [February 11, 2021, 11:38pm UTC](https://community.glideapps.com/t/customer-to-input-a-date-to-generate-a-list-relative-dates/22642/2 "2021-02-11T23:38:30Z")

</div>

Hey !

First of all, welcome on board the Glide Community ! If you need assistance, our friendly members will always do their best to help you ! (Help us help you 🙂)

About your issue, I think that the following link can give you some valuable advice ⬇

> [@ARRAYFORMULA to calculate DATE that is one year later than the given date?](https://community.glideapps.com/t/arrayformula-to-calculate-date-that-is-one-year-later-than-the-given-date/22456/3):
>
> Check your quotes. When I copy/pasted your original, it contained “smart quotes”. This works for me: =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).

Can you confirm ? Hope this helps.  
Once again, welcome !

---

_[View the full topic](https://community.glideapps.com/t/customer-to-input-a-date-to-generate-a-list-relative-dates/22642)._