Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Extract dates between 2 date fields

Topic Labels: Formulas
949 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Josh_Colina1
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there a formula anyone has used or encountered that can surface dates in between 2 dates? For example, if I have a “Start” date field and a “Due” date field, is it possible to extract the interstitial dates?

I.e.
Start: 1/1/22
Due: 1/5/22
Hypothetical Formula Field: 1/2/22, 1/3/22, 1/4/22

1 Reply 1
Lom_Labs
7 - App Architect
7 - App Architect

Hi, I have created formulas for each year up to 2025 to do this and they’re available on my Gumroad store: Formula: Extract dates between two date fields

Date Formula Example

You can select the output of the date format (friendly, US, European, ISO) too