# Array of dates between 2 dates - experimental column

**URL:** <https://community.glideapps.com/t/array-of-dates-between-2-dates-experimental-column/52511>\
**Category:** Ask for Help\
**Created:** [October 25, 2022, 10:24am UTC](https://community.glideapps.com/t/array-of-dates-between-2-dates-experimental-column/52511 "2022-10-25T10:24:48Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [October 25, 2022, 12:31pm UTC](https://community.glideapps.com/t/array-of-dates-between-2-dates-experimental-column/52511/4 "2022-10-25T12:31:48Z")

</div>

Okay, so what I would do:

- Write both start and end dates to user specific columns
- Use a pair of single value columns to apply those to all rows in your bookings table
- Create an if-then-else column:  
– If SV Start Date is after Booking End Date, then null  
– If SV End Date is before Booking Start Date, then null  
– Else true
- Then do a rollup on the if-then-else column, counting true values. If the result is greater than zero, then you have an overlapping date.

_NB. I may not have the if-then-else logic exactly right there - I might have missed a condition or two - but it should give you the idea_

---

_[View the full topic](https://community.glideapps.com/t/array-of-dates-between-2-dates-experimental-column/52511)._