# Two dates range comparison - ClickUp Make

Hello,

Is there any way that I can detect if there is common days between two date range?

For example, if we have the first task - start date: 7/10/2023 → due date: 7/15/2023,

and the second task - start date: 7/9/2023 → due date: 7/16/2023.

Thanks

To calculate the number of days between two dates, utilize this formula: {{round((7.`End Date` - 7.`Start Date` ) / 1000 / 60 / 60 / 24)}}.

Please ensure that you have employed date type data for both the End Date and Start Date.

Thanks & Regards

3 Likes

I don’t need the number of days, I want to detect if there is common days between two dates.

For the example, 7/10/2023, 7/11/2023, 7/12/2023, 7/13/2023, 7/14/2023 are the common days between the two dates I wrote before.

if we have the first task - start date: 7/10/2023 → due date: 7/15/2023,

and the second task - start date: 7/9/2023 → due date: 7/16/2023.

Thank you

1. Compare starting date and choose largest date.
2. Compare ending date and choose lowest date.
3. Put the collected date difference into the repeater module add the the repeater value with collected start date and collect all with text aggregator. If you want to make array with the result please use split with the text data

Thanks & Regards

2 Likes