
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 15, 2022 10:51 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21, 2022 06:17 AM - edited Feb 12, 2023 08:39 PM
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
You can select the output of the date format (friendly, US, European, ISO) too
