Adding dates to events
 

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
--
Wal

Adding dates to events
 

=(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.
--
David Biddulph

"Wally3178" wrote in message
...
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
--
Wal