Thanks to everyone who responded. Arkware's solution is exactly what I was looking for.

The input as I mentioned would be a datetime value. For each datetime value I want to determine what week range it belongs to, where a week starts on a...