# Add 60 multiple rows with dates (today + monthly additions)
**URL:** https://community.glideapps.com/t/add-60-multiple-rows-with-dates-today-monthly-additions/75308
**Category:** Ask for Help
**Created:** [July 31, 2024, 8:37am UTC](https://community.glideapps.com/t/add-60-multiple-rows-with-dates-today-monthly-additions/75308 "2024-07-31T08:37:39Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Matt\_Viner](https://community.glideapps.com/u/Matt_Viner)
#### Post date: [July 31, 2024, 8:37am UTC](https://community.glideapps.com/t/add-60-multiple-rows-with-dates-today-monthly-additions/75308/1 "2024-07-31T08:37:39Z")
Hello Gliders. I’m watching this great video on multiple row adding with API:
🎓 Glide Tutorial - Add, Edit or Delete Multiple Rows (Glide API)[https://youtu.be/b7\_k3\_brusQ?si=Q1m6cNPjbMURdCTR](https://youtu.be/b7_k3_brusQ?si=Q1m6cNPjbMURdCTR). Clear enough (for now) and I intend to do this.
But the rows I’m adding will have a date column. The first row can be today, and each row after should be +1 month. How to do?
Thank you as always
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 1, 2024, 1:33am UTC](https://community.glideapps.com/t/add-60-multiple-rows-with-dates-today-monthly-additions/75308/2 "2024-08-01T01:33:27Z")
I think your best bet would be using Make, with their Repeater module to repeat 60 times.
Use the addDays function in tandem with the repeater index to add the correct amount of days for each time you add a row to Glide.
---
### Author:  [@Matt\_Viner](https://community.glideapps.com/u/Matt_Viner)
#### Post date: [August 1, 2024, 8:58am UTC](https://community.glideapps.com/t/add-60-multiple-rows-with-dates-today-monthly-additions/75308/3 "2024-08-01T08:58:06Z")
Thanks for this. I ended up using the API method to bulk add rows, and included an index number in the bulk-add as well as a date added, then in the destination table it was easy to use math column to add a month based on the index number. It’s not flexible (i.e. can only add set number of rows) but it is contained within glide at least and for my purpose users can easily delete rows in the data table collection so having extra from the bulk add is ok
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 1, 2024, 2:22pm UTC](https://community.glideapps.com/t/add-60-multiple-rows-with-dates-today-monthly-additions/75308/4 "2024-08-01T14:22:01Z")
That’s also a great way to do it!
---
### Author:  [@Matt\_Viner](https://community.glideapps.com/u/Matt_Viner)
#### Post date: [August 2, 2024, 10:13am UTC](https://community.glideapps.com/t/add-60-multiple-rows-with-dates-today-monthly-additions/75308/5 "2024-08-02T10:13:14Z")
Hmm maybe not. Just noticed I’m stuck in the problem of adding days to get to the next month and Feb being too short. Here’s where I am:
1. API template adds with start date (could be any month / year), also adds index 1-48 (total number rows)
2. Destination then finds first day of month and then Math (firstdayofmonthcolumn+(30\*index)
3. Of course this skips Feb
4. It would seem easier in my case to find the last day of the month and add 1 day. Is this possible?
@Darren_Murphy I noticed your formula below, is there a way to adjust this so that I can use the index number to add x number of months?
## ((Now-DAY(Now)+15)+60)
DAY((Now-DAY(Now)+15)+60)
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 2, 2024, 10:15am UTC](https://community.glideapps.com/t/add-60-multiple-rows-with-dates-today-monthly-additions/75308/6 "2024-08-02T10:15:54Z")
> [@Matt\_Viner](#):
>
> I noticed your formula below, is there a way to adjust this so that I can use the index number to add x number of months?
Adding months is a bit tricky. Check the below thread for a couple of options:
> [@date Guide: Mastering Dates & Times](https://community.glideapps.com/t/guide-mastering-dates-times/70381):
>
> The Date & Time column contains both a date and time value within one single value. Dates and times can therefore be tricky to understand and to work with. It helps to keep things simple to stay out of trouble. Here are a few tips: Writing dates Avoid writing dates manually. Use a picker instead. If done via import, be weary of the format of the date column in the source. Relations Anytime you create a relation with a date, convert the date to either a string (template column) or a number (…
---
### Author:  [@Matt\_Viner](https://community.glideapps.com/u/Matt_Viner)
#### Post date: [August 2, 2024, 10:20am UTC](https://community.glideapps.com/t/add-60-multiple-rows-with-dates-today-monthly-additions/75308/7 "2024-08-02T10:20:31Z")
Exactly what I needed - thanks for the rapid response and super helpful reference guide!!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [August 9, 2024, 10:21am UTC](https://community.glideapps.com/t/add-60-multiple-rows-with-dates-today-monthly-additions/75308/8 "2024-08-09T10:21:17Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.