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
|