Hi,

I am using two formulas for calendar in Excel 2012 German version which are working perfectly in German office. When I open excel sheet in office 2007 Engl. Version and when I change year whole formula shows error of #NUM!

GERMAN FORMULA
“C2485” has formula ‘=WENN(TEXT($A2484;"TTT")=C2484;$A2484;""), cell format is date 09/11/2012, cell A has format customer YYYY MMMM
“D2485” has formula =WENN(TEXT($A2484;"TTT")=D2484;$A2484;WENN(C2485="";"";C2485+1))
“A284” has formula ‘=DATUM($A$1;11;1) cell formats customer YYYY MMMM
“A1 has format is “[$-407]MMMM JJJJ;@”

In company where I am using company’s PC and Office 2007 English version.

ENGLISH OFFICE 2007 FORMULA
So excel translated formulas as;
“C2485” has formula '=IF(TEXT($A2484;"TTT")=C2484;$A2484;"") ;""), cell format is date 09/11/2012, cell A has format customer YYYY MMMM
“D2485” has formula ‘=IF(TEXT($A2484;"TTT")=D2484;$A2484;IF(C2485="";"";C2485+1))
“A284” has formula ‘=DATE($A$1;11;1) ) cell formats customer YYYY MMMM
“A1” has format “[$-407]MMMM JJJJ;@”


When I open excel sheet in company with office 2007 (Engl. Version) the formula for calendar is showing me correct year and date. As I change year up or down in “A1” I got result #NUM!

What is wrong in formula or formats? Do you have any ideas?

Thanks for coming help

Excelianer