# 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:** 31

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 21, 2021, 12:08am UTC](https://community.glideapps.com/t/customer-to-input-a-date-to-generate-a-list-relative-dates/22642/31 "2021-02-21T00:08:55Z")

</div>

As I shared with you a couple of weeks ago, this would be the math to add any number of months to a date.

> [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684/77):
>
> Here you go. Just use 1.5 years for the number of years, or you can take your number of months and divide by 12. Same thing either way.

If I’m understanding you correctly, it sounds like you do want 36 (or any chosen number of months) separate rows. so then scripting would probably be the best way to handle adding additional rows. I would still consider a single row with date math that would dynamically update to the next occurrence of the date once the current date has passed. If I get some free time in the next few days I’ll see if I can come up with an example to explain what I mean. I do something similar in the example below, where an event can have a duration of multiple days. It only writes a single row, but the dates dynamically update every day until the duration has passed. It’s kind of a messy example, so it might be confusing to understand.

> **[Calendar Concept](https://nonchalant-creature-8307.glideapp.io/)**

---

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