excel formula
 

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

excel formula
 

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

"max power" wrote:

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

excel formula
 

On Sat, 30 Sep 2006 00:28:01 -0700, max power
wrote:

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


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


--ron