Calculating days in a range that fall within a financial year

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 + 1 to 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 🙏