how to script for finding maximum, minimum date value in a row for 100+ columns

[#1]

i have a table with 500+ rows and 100+ columns. Populated with numeric values (dates). I need to find the maximum and minimum value along each row for earliest and latest date. i guess the script would be similar to 'Maximum (column1........column100)' for each row. But i am not sure how to script the column ranges along each row.  

[#2]

Might this formula

If( Row() == 1,
	nc = N Cols( Current Data Table() )
);
Mean( As Column( nc - 4 ), As Column( nc - 3 ), 
	As Column( nc - 2 ), As Column( nc - 1 ) );

be something in the direction you are looking for