How to calculate days and break it into years

[Thilina_Wick]

Hi, I might have a bit of a weird requirement

I have 2 dates lets say 30th Sept 2019 to 4th April 2022 [User Input]

I want to calculate the days between those 2 dates but I need the days to be broken up by years

Result Should Be:

• 2019 - 93 days
• 2020 - 366 days
• 2021 - 365 days
• 2022 - 94 days

This is for a calculation which calculates a penalty for late payment (but the % changes each year so need to do the calculation for days in each year and add it up together)

I want to simply enter the dates in 1 record and for it to automatically check the days and calculate and add it up simply giving a single value for penalty

Thanks in advance for any help 😄