....a simple one but I'm stuck right now...

[damian_r_Home]

....a simple one but too much rich food has probably resulted in many brain cells being asleep still.


In a cell I have the formula =TODAY() so as you'd expect I see todays date in the format 28-Dec-20

However, if I tweak the formula to read ="Todays Date Is "&TODAY() all I see in the cell is Todays Date Is 44193

How can I get it to display as Todays Date Is 28-Dec-20?

Thanks in advance.

D

 

[Fluff]

How about

="Todays Date is " &Text(Today(),"dd-mmm-yy")

 

[damian_r_Home]

How about

="Todays Date is " &Text(Today(),"dd-mmm-yy")

Afternoon Fluff, I reckon over the years you have helped me many many times - thankyou!

 

[Fluff]

You're welcome & thanks for the feedback.