text and today's date in 1 cell

[rexie3]

I need to set up a cell to have today's date with the user's initials. For
example, ABC 2007/02/08. How do I do this? Please notice that the date
format is European. Thanking you in advance for your help.

 

[Gary''s Student]

=A1&TEXT(TODAY(),"yyyy/mm/dd")
if the initials are in A1

 

[David Biddulph]

="ABC "&TEXT(TODAY(),"YYYY/MM/DD")

 

[Earl Kiosterud]

Rexie,

You could put =TODAY() in the cell, and format it (Format - Cells - Number - Custom tab:

 

[rexie3]

Thank you so much! Now my headache is half gone...finally. I have another
posting that's much more complicated.

 

[rexie3]

Thank you David. Once again the Community has saved my brain.