Joining text with today's date

[klabtv]

Hello,
I’m trying to join text from a cell in my spreadsheet with today’s date in text format. To do this, I’m nesting several different formulas. But I’m having trouble getting the date in the text format. Any help would be appreciated.

Here’s my formula:
I first want to write today’s date
=TODAY ()
I also want to join the text in A7 with a comma separator
=CONCATENATE(TODAY(),",",J7)

My problem is that the date isn’t formatted the way I need it as a text value. What can I do to calculate the date as text formatted as MMDDYYYY?

[TMS]

Try:

Please Login or Register  to view this content.

[Pete_UK]

Try it like this:

=TEXT(TODAY(),"MMDDYYYY")&","&J7

Hope this helps.

Pete