Concatenate formula utilizing Today()

**wmfinance** · 08-12-2010, 10:18 AM

I'm using a concatenate formula, in conjunction with today(), so that every time I open up my master template it has the current date. The equation produces the wrong date which I found interesting:

=CONCATENATE("My"," ","Comments"," ","-"," ",TODAY())

The formula is sound,but shows: "My Comments - 040402"

Why is this happening/how can it be fixed?

Thanks!

**NBVC** · 08-12-2010, 10:24 AM

Try:

=CONCATENATE("My"," ","Comments"," ","-"," ",TEXT(TODAY(),"mm/dd/yyyy"))

you can change the mm/dd/yyyy format to what you desire.

**royUK** · 08-12-2010, 10:25 AM

TRy

=CONCATENATE("My"," ","Comments"," ","-"," ",TEXT(TODAY(),"dd/mm/yy"))

TDQ
NBVC

**arthurbr** · 08-12-2010, 10:27 AM

40402 is how XL sees today's date. By applying NBVC ' s formula you format it in a more usual way.
see how XL stores dates and times

**wmfinance** · 08-12-2010, 10:36 AM

Interesting, I was extremely confused when I saw that we lived in in 4/04/02 haha. I knew excel could do many things, but time travel????

Thanks a ton and reps have been bumped up.

**royUK** · 08-12-2010, 01:11 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save