Text / Date Formula Question

kellerh

New Member
Joined
Jul 20, 2005
Messages
18
I have a date in cell A1 = 12/15/05

What formula will give me the output: Daily data for 12/15/05 is:

instead of Daily data for 38701 is:
Thanks,
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Try

="Daily data for "&TEXT(A1,"mm/dd/yy")
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Like this?

="Daily data for "&TEXT(A1,"dddd")&" is:"
 

kellerh

New Member
Joined
Jul 20, 2005
Messages
18
That works great. Now for the finale as I continue to build this formula. How do I get the greek sigma symbol in a formula?
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
I am not sure if it will work but the character code in Excel for that symbol is 83

so the formula would containg, the function, char(83) but it may just return a capital S, you would have to change the font.

There is an add-in available here http://www.cpearson.com/excel/chars.htm, but I am not sure if it will insert the symbol as you want it again without change the font, to Symbol.

Maybe someone knows otherwise?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,763
Messages
5,574,096
Members
412,567
Latest member
mm1
Top