Input a year to determine the start date for 4-4-5 Calendar Year.

I basically want to be able to input a year, ex. "2012", and have excel spit out the start date of the fiscal year. My company is on a 4-4-5 calendar year, Saturday-Friday.
So for 2012, the start date for the calendar year is 12/31/2011.

Since Jan 2013 is a 5 week month, the year starts off as 5-4-5 for the first quarter.

Does anyone know of a VBA code or function that would work with this?

Thanks!

4-4-5 Week Accounting provides for non-standard accounting periods. While most companies end their year on December 31st or the last calendar day of some other month, my company ends the year on the last Friday of the year.

We divide each quarter of the year into three monthly periods consisting of two four week “months” of 28 days each and one five week “month” of 35 days, hence the name 4-4-5 Week Accounting Periods.

So typically each year, there are 52 weeks plus 1 day. So each quarter is 13 weeks at 4-4-5.

For leap years, it is 52 weeks plus 2 days. So every 5 to 6 years, we have a 53 week year.

2013 there are 53 weeks, so our company decided to go with 5-4-5 for the first quarter and then the second, third, and fourth quarter will be the standard 4-4-5.

Hopefully that explaination is correct.

I hope this also enlightens the understanding of 4-4-5 or 5-4-5

What I was looking for is just the month and year i.e Mar_13 from the date I got it to work with quite complicated formulae so if anyone wants s copy let me know