Adding dates to events

W

Wally3178

Hi,

I have built a spreadsheet for recording daily weather observations and am
in the process now of refining some of the features.

I have a display on the sheet for the highest and lowest temperatures of the
year but I don't seem to be able to link them to a date. Example, "The
highest temperature for the year was 45.6C on ?" I am using the 'max'
function to give me the temp can anyone suggest how I might be able to
complete the date?

Cheers,

Wally
 
D

David Biddulph

=(your formula)&" on "&TEXT(A2,"dd mmmm yyyy")
if A2 is the cell which contains the relevant date. Adjust the format in
the text function to suit your requirements.
 
Top