Adding Text and Date in same cell

[Cubicks]

I have an if statement that if true need to display the text "Added" and then today's date. I looked around online and tried to get it to work, no luck.

This is what I have: =IF('ES6 Raw'!K2="Offline",="Added" & TEXT(TODAY(),"dd-mm-yyyy"),"")

PS - I am working with about 2 hours sleep so, I am probably glazing over the solution.

Thank you very much.

 

[JEC]

Lol remove the "=" sign before "Added"

Time to sleep mate

 

[etaf]

=IF('ES6 Raw'!K2="Offline",="Added" & TEXT(TODAY(),"dd-mm-yyyy"),"")
change the = not needed
=IF('ES6 Raw'!K2="Offline","Added" & TEXT(TODAY(),"dd-mm-yyyy"),"")

 

[Cubicks]

Lol remove the "=" sign before "Added"

Time to sleep mate

I knew it was something simple. Thank you so much, this has taken me way too long to sort out. lol

 

[Cubicks]

Ok...is there a way to mark this post as solved?

 

[Cubicks]

Also, I joined on 3/12/04 and I am still a new member.

 

[JEC]

That is because of your amount of posts

 

[Cubicks]

That is because of your amount of posts

I know, I just thought it was funny. Thank you for your help, I am going to take a nap under my desk.

 

[Fluff]

Ok...is there a way to mark this post as solved?

To the right of each post you should see a gray bar with a tick in it. Just click on the tick for the post that helped you the most.

 

[Cubicks]

To the right of each post you should see a gray bar with a tick in it. Just click on the tick for the post that helped you the most.

TY