Need to calculate advance per week with a range of two dates.
I need to support to determine a formula that allows me To perform a weekly count of how many days (or if If any) will happen this week based on range of between 2 dates.
Today is 3/19/2020
Start Date End Date
This week will have a count = to 5 days from within that range. (3/16 - 3/20)
Next week they will have another 5 (3/23 - 3/27)and so on until we reach the end date's week when will have only 4 days that week (3/30 - 4/2 since that day is a Thursday)
This range will have zero days this current week since dates are on the future
This range will have Zero since the dates are in the past.
Help Article Resources
Check out the Formula Handbook template!