excel formula

M

max power

i am trying to get a cell to say "week starting (todays date).

so i put in the following formula

="week starting"&" "&TODAY()

however the result was

week starting 38990

any ideas?

and i need it all in the one cell so seperating the text and date is not an
option

thanx
 
M

max power

sorry folks have figured it out no need for help

in case any body is curious solution was:

format cell with custom formatting and add week starting as text befor date
format

thanx
 
R

Ron Rosenfeld

i am trying to get a cell to say "week starting (todays date).

so i put in the following formula

="week starting"&" "&TODAY()

however the result was

week starting 38990

any ideas?

and i need it all in the one cell so seperating the text and date is not an
option

thanx
Click to expand...


="week starting " & TEXT(today(),"mm/dd/yy")


--ron
 
Top