Support Request: Formula for a Date Range within a Date Range as a Percent of Time
Here is my dilemma -
We have many projects that fall within a date range over multiple years. We have a new report requested that uses the date range 7/1/22-6/30/23. We need to report the portion of the total award that falls within that time range out of the total time range.
We would greatly benefit from a formula that can extract this number.
Out of the date range 8/1/22-7/31/26, we want to know the portion of the date range that is 7/1/22-6/30/23 and the amount of the total award for that period of time.
Out of 48 months (8/1/22-7/31/26), 11 months of that range falls within the date range 7/1/22-6/30/23 is ~23% of the total time of the total date range. Taking .23 X 2,006,906 = ~461,588. For the next period, 7/1/23-6/30/24, that will be 12 months of that range and will be 25% X the total award amount which equals ~501,726 and so on.
Thanks in advance for the discussion!
Help Article Resources
Check out the Formula Handbook template!