Formula that Calculates Week Range and Labels Week Number Accordingly

Charlrog

When integrating our billing week system that alternates between billing weeks 1 and 2. Smartsheet should have a formula that allows for the duration to have a range based on weekdays that triggers to automatically label every other week with either week 1 or 2 accordingly.

ie.

Week Start Date End Date Name Total Hours

1 Jan 9 Jan 14 Charlotte 48

2 Jan 16 Jan 20 Charlotte 30