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.
Joel G Mathew, known in tech circles by the pseudonym Droidzone, is an opensource and programming enthusiast.
His favorite pastime is grappling with GNU compilers, discovering newer Linux secrets, writing scripts, hacking roms, and programs (nothing illegal), reading, blogging. and testing out the latest gadgets.
When away from the tech world, Dr Joel G. Mathew is a practising ENT Surgeon, busy with surgeries and clinical practise.