add text to todays date

[John Caines]

Hello all,
I'm just trying to add some text to todays date,, just can't get it

I have:

=TEXT,Today, The Day & Date Is:-"TODAY(dddd/dd/mm/yyyy)

I'm not sure what is wrong?? Can't be far off?
Any Ideas Please,,,
It's meant to say;
Today, The Day & Date Is:- Monday 13th February 2012

I hope someone can advise.

Many Thanks
john C

 

[Tom Urtis]

At least 3 ways.

This keeps it as a date:

Show text with today's day of week, example in a cell enter =TODAY() and custom format as "Today is" DDDD

or with text

="Today is "&TEXT(A1,"DDDD, MMMM, D, YYYY")
if the date is in A1

or just

="Today is "&TEXT(TODAY(),"DDDD, MMMM, D, YYYY")

 

[jproffer]

="Today, The Day & Date Is:- " & TEXT(WEEKDAY(TODAY()),"ddddddd") & ", " &  TEXT(TODAY(),"dd,mmmm,yyyy")

 

[T. Valko]

Hello all,
I'm just trying to add some text to todays date,, just can't get it

I have:

=TEXT,Today, The Day & Date Is:-"TODAY(dddd/dd/mm/yyyy)


I'm not sure what is wrong?? Can't be far off?
Any Ideas Please,,,
It's meant to say;
Today, The Day & Date Is:- Monday 13th February 2012

I hope someone can advise.

Many Thanks
john C

If you want to include the ordinal day it's a bit more complicated...

="Today, The Day & Date Is:- "&TEXT(NOW(),"dddd d")&MID("stndrdthstndrdthst",MATCH(DAY(NOW()),{1,2,3,4,21,22,23,24,31})*2-1,2)&TEXT(NOW()," mmmm yyyy")

 

[John Caines]

Hi Tom!!!!!!!!!
Long time no hear,,

Many thanks for your suggestions,, working a treat!!
Great stuff,, many thanks......

I remember ,, oh a long long time ago you helped me with a few bits for a spreadsheet..

Really weird,,,
(I'll cut it short as my eyes are burning,, must get my head down,, its 3am here in UK,, been on PC too long)

No,, 100% serious,, I was thinking about you earlier tonight,, really.(Nothing sinister I can assure you)

I'm trying to format a spreadsheet ,, and it needs like maybe 5-6 clear buttons.
As you can tell but my post,, my VB skills are just above zero.

I was thinking how best to do it,,,,,
& I remembered you done a really really cool pop up once in VBA for a spreadsheet of mine,, years ago
let me see if I can quickly find in on HD,,,,,,,,,,,

Dame it,, I can't see it now,,
But I remember you created a pop up for me that had little circles you could check,, it had like 6 different selections,,,

So,, my thinking was maybe best to implement something likethis,, "Tom Urtis Stylee"
So,, 6 ways to clear the sheet,, all within 1 pop up,,
IE
1. Clear All Sheet
2 clear Just xyz
3. clear just fgh
4. User define,, (If selected,, a pop up would appear and you couuld insert numbers separated by commas etc


OK,, I'm digressing,,
I'll have to look at this tomorrow,, & may be post for it.
Many thanks again Tom.

I hope life is treating you good.

All the best,,
& again many thanks
John Caines

 

[Rick Rothstein]

="Today, The Day & Date Is:- "&TEXT(NOW(),"dddd d")&MID("stndrdthstndrdthst",MATCH(DAY(NOW()),{1,2,3,4,21,22,23,24,31})*2-1,2)&TEXT(NOW()," mmmm yyyy")

Biff... you gave up on "our" formula?

="Today, The Day & Date Is:- "&SUBSTITUTE(TEXT(TODAY(),"dddd d\@ mmmm yyyy"),"@",MID("thstndrdth",MIN(9,2*RIGHT(DAY(NOW()))*(MOD(DAY(NOW())-11,100)>2)+1),2))

EDIT NOTE
-----------------
Or using your construction...

="Today, The Day & Date Is:- "&TEXT(NOW(),"dddd d")&MID("thstndrdth",MIN(9,2*RIGHT(DAY(NOW()))*(MOD(DAY(NOW())-11,100)>2)+1),2)&TEXT(NOW()," mmmm yyyy")

 

[Tom Urtis]

"Tom Urtis Stylee"

Well *that* has a nice flair for a product name!

Seriously, thanks for your kind words, but I cannot recall what you are referring to that I helped you with for 6 ways to clear a sheet. Sounds like OptionButtons but don't know if this was a userform or a dialog sheet. I'll be about all week so feel free to post back with what you are asking about...or for best results start a new thread if it is a different topic than the formula question you asked here.

BTW and maybe most important for the short term, the other formula solutions offered by jproffer and T. Valko speak more to the specifics of your first post than my suggestions did. Give those other formulas a shot too...[edit, or the one crossposted immediately preceding]...they look like those gentlemen hit the target more than my formulas did based on the literal nature of your first question.

 

[T. Valko]

Biff... you gave up on "our" formula???

Nah, I just figured it's bit easier to use that other bit when getting the ordinal day.

 

[John Caines]

Found your code Tom!!
Here's the screen shot of the pop up!

I've really got to get my head down,, my eyes really are burning,,

I must say many thanks again to T Valko & jproffer for your replies,,
& Rick Rothstein....

As a note,, Tom's formula does the trick for me.
I was just wanting to put some words infront of the date etc.

I see you guys are well,, kind of converting it all to text.

I'm not sure why anyone would need to do this?
But again,, many thanks for all your help.

& thanks Tom for saying;;

I'll be about all week so feel free to post back with what you are asking about...or for best results start a new thread if it is a different topic than the formula question you asked here.

I'll try and sort it out tomorrow.
(I won't try,, I will do,,)

All the best
John Caines

 

[Tom Urtis]

OK, I do remember that image which is a dialog sheet, the code for which I posted for you way back when. So post back when you are ready to follow-up, to that same thread would be best if it deals with a modification you want made to that dialog sheet interface.