Hi,

I am trying to use the following 
="Some text goes here "&F6+30&"."
which displays something like 41869. In the cell F6 I have used =Today() which works as intended. I am simply trying to add 30 more days. I've tried searching for similar issues and tried a few things to solve it but no luck so far.

Some of the things I did:
Selecting the cell and formatting it, however it did not make any difference. I've also checked under settings > advanced > that formulas in cells is unchecked. Then I tried using the following 
Some text goes here "&Today()+30&"."
but that produced the same result.

How can I display the date (30 days ahead) in the format dd-mm-yyyy.

I am using Windows 7 with Office 2007.

Thanks in advance,