Identifying Number of Days in a Given Period for Each Fiscal Year

[jeffr3]

Hi,

I'm trying to identify the following:

I have a start date column and an end date column. I need to find the number of days falling into each Fiscal Year range. FY goes from 06.01 - 05.31 for every year (2020.06.01 would be first day of FY21).

For example, if a given row has a start date of 05.30.2020 and end date of 06.03.2020, then I need it to spit out FY20 # days = 2 and FY21 # days = 3.

Is this possible?

Thanks!

[TheOC]

Glad you got it sorted @jeffr3 !


cheers,
TheOC

[Shifty]

Fantastic!  Good luck with your use case.