Set format of date, concatenated with string
<p>I would like to get the following string as a date formatted:</p>

<pre><code>="Status: "&amp; TODAY()
</code></pre>

<p>However, I get:</p>

<pre><code>Status: 42418
</code></pre>

<p>I would like to get:</p>

<pre><code>Status: 18.02.2016
</code></pre>

<p>I already tried to change the format to Date or use the <code>Datevalue</code> function.</p>

<p>Any suggestions, how to get the current date correctly formatted?</p>