View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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