Hi all,
I'm working on a Master calendar, where i'm trying to make the fiscal week of every year the week starts on suday. the fiscal year star on nov 1st.
| DateKey | FiscalWeek |
| 11/1/2012 | 1 |
| 11/2/2012 | 1 |
| 11/3/2012 | 1 |
| 11/4/2012 | 2 |
| 11/5/2012 | 2 |
| 11/6/2012 | 2 |
| 11/7/2012 | 2 |
| 11/8/2012 | 2 |
| 11/9/2012 | 2 |
| 11/10/2012 | 2 |
| 11/11/2012 | 3 |
| 11/12/2012 | 3 |
| 11/13/2012 | 3 |
| 11/14/2012 | 3 |
| 11/15/2012 | 3 |
| 11/16/2012 | 3 |
| 11/17/2012 | 3 |
| 11/18/2012 | 4 |
| 11/19/2012 | 4 |
| 11/20/2012 | 4 |
| 11/21/2012 | 4 |
| 11/22/2012 | 4 |
| 11/23/2012 | 4 |
| 11/24/2012 | 4 |
| 11/25/2012 | 5 |
| 11/26/2012 | 5 |
| 11/27/2012 | 5 |
| 11/28/2012 | 5 |
| 11/29/2012 | 5 |
| 11/30/2012 | 5 |
| 12/1/2012 | 5 |
any help is wellcomed.
.
