Can I use Today() function in between a string using &-s in between and get the right date format?

="Todays date is"&TODAY()
this is returning
Todays date is 40520

But I need like this.

Todays date is 12/08/2010

Instead of writing one formula u can write multiple formula and then concatenate it, so that the date won't get converted into number. The formula in COLOUMN F needs to be written first in accordance with the number mention and afterwards the main formula than u needed. Go through the sample attachment for reference.

Attached Files

date file.xls (17.0 KB, 14 views)

Thanks Nirik. This gives me an idea how to go about. Thanks

Or use:

Cheers,

Hi,
here is another solution for a formula:

="Today's date is "&TEXT(TODAY();"DD/MM/YYYY")

(you must only check that this date format is correct for you, I can't check it because I use Swedish date formats).

Kind regards
Bjorn