Date format together with a string

[dotsent]

Hi!

Struggling to find a formula (or cell formatting?) to present proper date next to a string. This works fine to present a correct date 5 days from now: =TODAY()+5 however I would need to run something like this: ="5 days from today is "&TODAY()+5 - I'd prefer to keep them together for cleaner formatting purposes, although having a string and date in different cells would obviously work fine.

The current result is 5 days from today is # (with # being what I believe is DATEVALUE in Excel? e.g. 43472). Is there a way to make Excel present the date in a normal manner as mixing a string to the formula seems to convert the date into Excel's own format? Should it matter, the desired format is dd.mm.yyyy

Thanks a lot for any ideas!

 

[Fluff]

How about
="5 days from today is "&TEXT(TODAY()+5,"dd.mm.yyyy")

 

[dotsent]

Murphy's Law at work. Thought I had gone through all the options I found in the web, but stumbled on pretty much the same solution minutes after posting the thread. Thanks a lot and it really did do the trick!

 

[Fluff]

You're welcome & thanks for the feedback