a1 = number - a2 = the date error message appears to have issue with ( after the use of TEXT?

=IF(A1>0;"OMRU Accounts for the "&A1&" months ended"&Text(a2,"DD-MM-yyy""); " ")


also - if cell has a value and that value can be changed - how do I write a formula to add a particular range ie cell value is 3 - the sum of A1.c1 - cell value is 6 - A1.f1 - cell value is 9 - a1.p1 )

please help