An example is provided below:
="ABSTRACT OF CERTIFICATES ISSUED IN THE MONTH OF " &TEXT(TODAY(),"MMMM") &" " &TEXT(TODAY(),"YYYY")
This displays the following:
ABSTRACT OF CERTIFICATES ISSUED IN THE MONTH OF May 2013
Note that Formulae can be combined by using Ampersands (&) and spaces in between them. The cell has to begin with the equals sign (=). Text should be quoted in double quotes. Formulae can be grouped into parentheses.