Excel: Format TODAY() / DATE
<p>1) I would expect in E14 "Today is 13.09.2016", because E16 is formatted as DATE (customer)! But there is a general number instead of date. Why is Excel not able to copy the content of E16 !! How can I get the date in this position?</p>

<p>PS: If you suggest me <code>="today is "&amp;today()</code>, then please explain me, how I can  format the date in YYYYMMDD as in the screenshot</p>

<p><a href="https://i.stack.imgur.com/BKyIT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BKyIT.png" alt="Screenshot"></a></p>