I have a calculated field [Current Year] in Text Format:


which displays "2019" in Text Format.

But I also want to create a new Column with a calculated column that is next year (also in Text format as above)

I tried (logically I thought)


But it gave 2,020!! NOT "2020".

Please can someone suggest the Calculation for Next Year in Text Format. So it appears as (in this case) 2020.

Thanks in advance.

1 Answer 1


Try the below formula.


For details please refer to this article from Microsoft

  • Superb! works perfectly - Thank You
    – David
    Apr 5, 2019 at 9:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.