ExcelBanter - How can the "NOW()" function be used in text.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can the "NOW()" function be used in text. (https://www.excelbanter.com/excel-worksheet-functions/16337-how-can-%22now-%22-function-used-text.html)

DWW1945

How can the "NOW()" function be used in text.

I would like to have a current date in a sentence within a spreadsheet.

Bob Phillips

="Today's date is "&TEXT(TODAY(),"dd mmm yyyy")

--

HTH

RP
(remove nothere from the email address if mailing direct)

"DWW1945" wrote in message
...
I would like to have a current date in a sentence within a spreadsheet.

Max

Try something like :

="The date / time is: "&TEXT(NOW(),"dd-mmm-yyyy h:mm AM/PM")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"DWW1945" wrote in message
...
I would like to have a current date in a sentence within a spreadsheet.

All times are GMT +1. The time now is 01:09 AM.