Hello,

I have one more problem again!

I have my working hours on sheets sheet1:sheet12 on D7:D37 and on C7:C37 I have my working days like 1.1.2012.
On sheet 13 I have max function, which finds the longest working day from all sheets, but the question is, how can I get the excel find the date which the longest working hours are concerning on? Id like the sheet to return for example 12.08.2012 if that is the date I did the longest work day.

Hope some one can help me..

Cheers,

Tuomas