Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
.