Thread: excel formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
max power max power is offline
external usenet poster
 
Posts: 15
Default 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