Today plus 30 days is showing numbers instead of a proper date

Hi,

I am trying to use the following

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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,

Originally Posted by FDibbins

Hi and welcome to the forum

a date is just a number representing the number of days passed since 1/1/900...and then formated in a way that we recognise as a date

So for combining date/numbers and text, you need something like this...

="Some text goes here "&TEXT(F6+30,"mm/dd/yy")&"."

You can change the sequence and the seperator of needed

Hi, thank you.

It worked though I had to modify it a little bit, to: ="Some text goes here "&TEXT(F6+30; "mm/dd/yy")&"."
Thanks for the fast reply and help