Calculated formula

How can I create a column with a calculated formula that calculates the second largest value in a range of columns that vary according to the period (at least 7 columns)?