Thx to all for help with solving this. Very much appreciated !!! Tom

I'm using this version...

Apache Open Office 4.1.6

AOO416m1(Build:9790) - Rev. 1844436

2018-10-23 12:57

I'm getting an ERR:509 when I try to use the following EXCEL formula in my AOO Calc spreadsheet. Could someone assist me to convert it ? Thx, Tom

=CHOOSE(MOD(COLUMNS($a:a)-1,4)+1,"1st","2nd","3rd","4th")&" Qtr "&2018+ROUNDUP(COLUMNS($a:a)/4,0)