combining values within formula

[mort1703]

Hi

I am trying to combine this statement "The report was approved on " with today's date automatically

Formatting required is

The report was approved on 11 March 2018

I have tried using the CONCATENATE function as follows

=CONCATENATE("This report was approved on ",TODAY())

however it outputs the following

This report was approved on 43170

how do I modify this to what I require, any help would be great

 

[mumps]

Try: ="This report was approved on "&TEXT(TODAY(),"dd/mm/yyy")

 

[jtakw]

Hi,

Just a slight adjustment to mumps solution:

Excel 2010
	E
1	This report was approved on 11 March 2018
Sheet1

Cell Formulas
Range	Formula
E1	="This report was approved on "&TEXT(TODAY(),"dd mmmm yyyy")

The problem; however, is that by using the TODAY function, the date will change/update everyday.