Formula of Calculated Column

Question

I want to make a formula to my calculated column :

If the DD Rating is High => Add 3 months to the [DD Sign-off Date] If the DD Rating is Medium=> Add 6 months to the [DD Sign-off Date] If the DD Rating is Low => Add 12 months to the [DD Sign-off Date]

So the formula must be like this :

  =IF([DD Rating]="High",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+3,DAY([DD Sign-off Date])),"dd/mm/yyyy")),
   IF([DD Rating]="Medium",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+6,DAY([DD Sign-off Date])),"dd/mm/yyyy")),
   IF([DD Rating]="Low",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+12,DAY([DD Sign-off Date])),"dd/mm/yyyy"))

Answer 1

All example formulas in this topic use commas "," as the parameter delimiter character. In some countries, the comma is reserved for use as the decimal mark. In such countries, users creating a calculated field must use semi-colons ";" as the delimiter character.

Try using:

=IF([DD Rating]="High";
TEXT(DATE(YEAR([DD Sign-off Date]);MONTH([DD Sign-off Date])+3;DAY([DD Sign-off Date]));"dd/mm/yyyy");
   IF([DD Rating]="Medium";
TEXT(DATE(YEAR([DD Sign-off Date]);MONTH([DD Sign-off Date])+6;DAY([DD Sign-off Date]));"dd/mm/yyyy");
   IF([DD Rating]="Low";
TEXT(DATE(YEAR([DD Sign-off Date]);MONTH([DD Sign-off Date])+12;DAY([DD Sign-off Date]));"dd/mm/yyyy"))))

Answer 2

Try Using below Formula:

=IF([DD Rating]="High",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+3,DAY([DD Sign- off Date])),"dd/mm/yyyy"),
   IF([DD Rating]="Medium",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+6,DAY([DD Sign-off Date])),"dd/mm/yyyy"),
   IF([DD Rating]="Low",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+12,DAY([DD Sign-off Date])),"dd/mm/yyyy"))))