Hi, I'm running into an issue with Excel 2013.

I'm using the follwing formula.
=TEXT(CONCATENATE(INT((A$3-DATE(YEAR(A$3-WEEKDAY(A$3-1)+4),1,3)+WEEKDAY(DATE(YEAR(A$3-WEEKDAY(A$3-1)+4),1,3))+5)/7),"-",A1),"mm-jjjj")

In Excel 2010 this works perfectly. However when I open the file in 2013 it will display as 41-JJJJ. JJJJ should print the year. Changing this to YYYY doesn't work. If I open the file in 2010 after opening it in 2013 it will give the same problem in 2010. This can be fixed by selecting the formula and hitting enter.
In 2013 I can't get it to work at all. It seems 2013 uses the regional setting differently. I'm using 2013 in a citrix enverinment, i'm not sure what it uses as regional setting.

Does anyone have a workaround that works in all versions of excel?