I've got 31 columns (one for each day), not every day has a value, but I want to be given the date of the value that's the farthest left, how do I do this?
You just have to enter the formula I suggested, then press F2 to enter edit mode and click the name of the function to obtain help on it. By the way, please let me know if the formula returns your desired result.