I am marginally competent in Excel, but have encountered a problem that has me stumped.

It seems pretty basic, but I cannot get this formula to work right:

=CONCATENATE("Total due as of ",TODAY()," to Vincente")


Everything works, except that the embedded TODAY() function displays as the pointer to the date (number of days since January 1, 1900) rather than the date itself.

How can I fix this?

tanstaafl.