Forum Discussion
Fiscal Year Calculated Columns
With due respect to Treb, the proposed solution by offsetting the week number will work well for year 2016. When you hit the year 2017 with 19/06/2017 as the start of new fiscal year the formula for week number will fail.
trebgatte correct me if I am wrong.
The solution proposed by me is a generic one and will work for any year and also any starting fiscal year date.
Attaching the screen shot for your reference.
With due respect to Treb, the proposed solution by offsetting the week number will work well for year 2016. When you hit the year 2017 with 19/06/2017 as the start of new fiscal year the formula for week number will fail.
trebgatte correct me if I am wrong.
The solution proposed by me is a generic one and will work for any year and also any starting fiscal year date.
Attaching the screen shot for your reference.
Anonymous, true the date would change, though I was shooting for consistency with the specific week of the year. Fiscal calendars are typically week/quarter specific, where the beginning of week 25 happens to be 6/19 this year. The approach I took was simply to offset the week number so that Fiscal week one is now calendar week 25.
Make sense?
Treb Gatte | Business Solutions MVP | Coffee Break Business Intelligence Videos
CheenUSing - thanks very much for your suggestion!
Treb - you are correct - each financial year doesn't start on June 19th. I just need the week numbers to line up from 1-52 each year.
On another note, any idea what formula would work for the 2-week time periods?
Thanks - Pete
