Hi everyone,
I’m hoping someone can help me figure out the correct formula for this — I’ve tried multiple variations but keep getting wrong results.
I have two separate columns: {Start Date} and {End Date}. I am trying to write a formula to return the number of days between these two dates that fall between 1 April 2025 and 31 March 2026.
What I’ve tried so far:
IF(
AND(
{End Date} >= DATE(2025, 4, 1),
{Start Date} <= DATE(2026, 3, 31)
),
DAYS(
MIN({End Date}, DATE(2026, 3, 31)),
MAX({Start Date}, DATE(2025, 4, 1))
) + 1,
0
)
- I understand that
DAYS()excludes the start date, so I added+ 1to make it inclusive. - So far, no matter what tweaks I can try the result always seems to come back as 0.
My main question:
✅ Does anyone have a working formula that accurately counts how many days within {Start Date} and {End Date} fall within a defined period?
✅ Any tips for common pitfalls I might be missing with DAYS(), MIN(), or MAX() functions?
Any help or working examples would be really appreciated!
Thanks so much in advance 🙏