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!