data validation and using hyperlink to email
 

Hi there,
I am creating a spreadsheet that contains dates and places.
However the columns that contains dates, I have used a data validation pull
down box, so other users can make their selection.
I want to add a hyperlink to these columns so that when they click on the
date, they will be redirected to a new email message.
I have tried to use the hyperlink function and thought I was doing it right,
but for some reason the link isn't working after when I go back to that cell,
even though the date is highlighted blue and underlined.

can someone please tell me what I am missing???