Ssoriano0127
New Member
- Joined
- Jan 23, 2018
- Messages
- 5
Hello all!
First time posting here! Just joined the site!
I had a question about having a range of dates listed between two dates. For example. Lets say my date ranges are 4/18/2016 - 12/18/18, What formula can I use to have excel populate every 3 months within that date range starting with 4/18/2018. I would need it to appear like this:
4/18/2016
7/18/2016
10/18/2016
1/18/2017
and so on until I reached 12/18/2018.
I know about the fill function but that just listed every month in that date range. I specifically need it spaced three months apart.
Hoping somebody can help!
Thanks!
First time posting here! Just joined the site!
I had a question about having a range of dates listed between two dates. For example. Lets say my date ranges are 4/18/2016 - 12/18/18, What formula can I use to have excel populate every 3 months within that date range starting with 4/18/2018. I would need it to appear like this:
4/18/2016
7/18/2016
10/18/2016
1/18/2017
and so on until I reached 12/18/2018.
I know about the fill function but that just listed every month in that date range. I specifically need it spaced three months apart.
Hoping somebody can help!
Thanks!