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