formula to determine week #s included in range of dates (start/finish)
I am trying to figure out a formula which will return the week numbers for a range of dates... for example, a task with start date of July 15 and a finish/due date of July 30 would fall across week #s 28, 29, 30.
The goal is to run a filter to display work for a particular week (or multiple weeks). I'm having trouble with how to create this and there may be a different (and better) solution which may accomplish the same thing... any help is welcome and needed! Thank you, in advance, for taking a look at this and helping me!
Below is an image of what I would like to do... I just can't figure out how to calculate and display the multiple weeks!
Help Article Resources
Check out the Formula Handbook template!